Hi !
When I insert a new record to a table "table_A" I want to Grant a Role
"Role_X" to the User "User_Y".
So I made a Trigger who should do this work, but it doesn't:
When I write: "GRANT Role_X TO User_Y" in the Trigger:
--> my Trigger ist invalid (error = ora-04098)
When I declare a varchar-Variable within the trigger, fill it with:
"GRANT Role_X TO User_Y" and then : "EXECUTE IMMEDIATE <variable>"
--> my Trigger is valid, but when it fires I get the error:
ora-04092 - cannot COMMIT in a Trigger
Can anybody help me ?
Is it anyhow possible to GRANT a ROLE after inserting a record ?
Thanks in advance for any help or comments
Ralf