Script Grant Synonym

SELECT  ‘GRANT ALL ON ‘ || OBJECT_NAME || ‘ TO UMENU;’

FROM USER_OBJECTS

WHERE OBJECT_TYPE IN (‘TABLE’,’VIEW’)

union

SELECT  ‘GRANT EXECUTE ON ‘ || OBJECT_NAME || ‘ TO UMENU;’

FROM USER_OBJECTS

WHERE OBJECT_TYPE IN (‘FUNCTION’,’PROCEDURE’,’PACKAGE’)

union

SELECT ‘CREATE OR REPLACE SYNONYM UMENU.’||OBJECT_NAME|| ‘ FOR DBADMIN.’||OBJECT_NAME||’;’

FROM USER_OBJECTS

WHERE OBJECT_TYPE IN (‘FUNCTION’,’PROCEDURE’,’PACKAGE’,’TABLE’,’VIEW’)

UNION

SELECT ‘CREATE OR REPLACE SYNONYM UMENU.’||OBJECT_NAME|| ‘ FOR DBADMIN.’||OBJECT_NAME||’;’

FROM USER_OBJECTS

WHERE OBJECT_NAME IN (‘NOREFFKU’);