Hi Everybody,
I am using oracle 8.1.6 db.
I want to create a trigger which fires for every new object created
in a particular schema. Basically, i want to grant privileges for
this newly created object to Roles, Users dynamically as and when
the new object created.
When i tried , the trigger got created but on creating a table
in that schema reported that " DDLs are not allowed in System
triggers except ALTER....COMPILE... " - command failed.
Is there any workaround to achieve issuing DDLs ?
Thanks.
Regards,
Arul.
Received on Mon May 14 2001 - 05:20:52 CDT
