Scripts

Generate grants statements

select ‘grant select,insert,delete,update on ‘ || owner || ‘.’ || table_name || ‘ to app_role;’ from dba_tables where owner=’XYZ’ ;

Generate synonyms

select ‘create or replace public synonym ‘ || table_name || ‘ for ‘ || owner || ‘.’ || table_name || ‘ ;’ from dba_tables where owner=’XYZ’ ;