Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> grant in trigger

grant in trigger

From: peter <hhh.database_at_gmail.com>
Date: Wed, 27 Jun 2007 01:58:48 -0700
Message-ID: <1182934728.052466.83860@k29g2000hsd.googlegroups.com>


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 2
Received on Wed Jun 27 2007 - 03:58:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US