• State Not Answered
  • Replies replies
    9
  • Subscribers subscribers
    25
  • Views views
    1151
  • Users 0 members are here
  • Locked Locked
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Using JDBC driver to "CREATE USER" on Oracle DB

Engywook88

Hi everyone,

I'm new to this forum and I need your help . My problem is that i have to integrate the NetIQ product with a DB oracle on which i have to create new users and assign them grants. I ask you, for the creation user part, if it is possible to use just the "CREATE USER" statement or if the driver fails to interface with the Oracle engine and therefore i have to use "INSERT" on specific Oracle Tables.

 

Thanks in advance for your support

P.S. Sorry for my English

Parents
  • 0

    Every DB is pretty much different.  Some DB's do actually have constructs called Users (for logging into the DB itself).  Most applications 'make' their own users inside the tables for their database.

    That is, ask your application owner, what a user should look like, and more specifically if they could provide an example SQL statement to make a user the way they want.

    Then using Norberts link to the docs you can build a SQL statement to match and use IDM features to get the data needed inside the statement.

    Or you could try and map the table to user class, and map the attributes to the rows if that would work.

  • 0 in reply to Geoffrey Carman

    Sorry again, but i'm al bit confused. In the link posted by Norbert i see that in the statement type (methods-for-executing-sql-statements) is not present the CREATE USER / ALTER statement. I'm able to pass this statement in a query or what ?

    "Generally, it is not possible to run a Data Definition Language (DDL) statement in a database trigger
    because most databases do not allow mixed DML and DDL transactions. Although virtual triggers do
    not overcome this transactional limitation, they do allow DDL statements to be executed as a side
    effect of an XDS event."

    P.S. I remind you that I don't know the DB schema.

    Thanks in advice.

Reply
  • 0 in reply to Geoffrey Carman

    Sorry again, but i'm al bit confused. In the link posted by Norbert i see that in the statement type (methods-for-executing-sql-statements) is not present the CREATE USER / ALTER statement. I'm able to pass this statement in a query or what ?

    "Generally, it is not possible to run a Data Definition Language (DDL) statement in a database trigger
    because most databases do not allow mixed DML and DDL transactions. Although virtual triggers do
    not overcome this transactional limitation, they do allow DDL statements to be executed as a side
    effect of an XDS event."

    P.S. I remind you that I don't know the DB schema.

    Thanks in advice.

Children

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.