Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant in trigger
peter wrote:
> On Jun 27, 8:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> peter wrote: >>> 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 >> What is the business case for writing this abomination?
>> -- >> Daniel A. Morgan >> University of Washington >> damor..._at_x.washington.edu (replace x with u to respond) >> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - >> >> - Show quoted text -
This is a case where two things should happen:
There is no technical solution for bad management.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Jun 29 2007 - 14:54:08 CDT