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.

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.

https://www.netiq.com/documentation/identity-manager-47-drivers/jdbc/data/how-to-execute-ddl-statements-in-jdbc-driver.html has an example with an embedded CREATE USER statement.

https://www.netiq.com/documentation/identity-manager-47-drivers/jdbc/data/how-to-execute-ddl-statements-in-jdbc-driver.html has an example with an embedded CREATE USER statement.

The code above the sql statement is necessary to complete the creation of the user and activate the trigger? Or i can simple use:

Andrea