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).