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
cducdu
Messages: 3
Registered: November 2006
Junior Member
Hello,
i have creating a trigger on create in a schema with the following code:
begin
execute immediate 'grant select on ora_dict_obj_name to user_report';
end;

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 ?
thx

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Commit on a report column link
Next Topic: Calling the wwsec_api from application express
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 06:08:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.