Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> grant in trigger
how to give execute grant command in trigger as execute immediate is
not working in it.
SQL>CREATE OR REPLACE TRIGGER Try
2 AFTER CREATE
3 ON database
4 BEGIN
5 execute immediate 'grant select on scott.chk to hr';
6 end;
7 /
Trigger created.
Elapsed: 00:00:00.00
SQL>create table scott.b(b number);
create table scott.b(b number)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-30511: invalid DDL operation in system triggers ORA-06512: at line 2Received on Wed Jun 27 2007 - 03:58:48 CDT