Oranew
asked on
Let Oracle Trigger do the work
I need to create a trigger to create the synonyms when any new table is created.
Currently; this is a manual task as below:-
Create created (say Test). Create table test a(number);
After that the manual tasks as below:-
create public synonym test for test;
grant select,insert,delete on test to emp_role;
I need help in automate the process using trigger. ( The trigger should create the synonym for the new objects and also grant privileges to roles).
Currently; this is a manual task as below:-
Create created (say Test). Create table test a(number);
After that the manual tasks as below:-
create public synonym test for test;
grant select,insert,delete on test to emp_role;
I need help in automate the process using trigger. ( The trigger should create the synonym for the new objects and also grant privileges to roles).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER