Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » grant inside trigger
grant inside trigger [message #204649] Tue, 21 November 2006 09:01 Go to next message
Messages: 3
Registered: November 2006
Junior Member
i have creating a trigger on create in a schema with the following code:
execute immediate 'grant select on ora_dict_obj_name to user_report';

any error occur during compilation, but when i create e new table i have: ORA-30511: invalid DDL operation in system triggers

Is it possible to grant inside a trigger ? if yes how could i do that, or what is the other way to do that ?
Re: grant inside trigger [message #206356 is a reply to message #204649] Wed, 29 November 2006 13:34 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Yes, try autonomous transactions. If you can't define an autonomous tx in the trigger itself - create a stored proc having it - and then call that from the trigger.
Previous Topic: Commit on a report column link
Next Topic: Calling the wwsec_api from application express
Goto Forum:

Current Time: Sat Jan 28 22:52:42 CST 2023