Script to create grants and synonyms for objects in database
704459Oct 7 2009 — edited Oct 7 2009Hello,
We are building a patch to be applied to the production environment. I want to create a script/sql query that builds a list of grants and synonyms for all the objects created after august 09.
for ex:
create or replace synonym abc for schema_name.abc;
.
.
Grant execute on abc to user_xyz;
How can I use Oracle's data dictionary to do this?
thankz