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.