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’);

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: