SELECT 'GRANT select on OWNER_NAME.'|| view_name||' to USER_NAME ;' FROM dba_views WHERE owner = 'OWNER_NAME'
SELECT 'GRANT select on OWNER_NAME.'|| table_name||' to USER_NAME ;' FROM dba_tables WHERE owner = 'OWNER_NAME'
SELECT 'GRANT execute on OWNER_NAME.'||object_name||' to USER_NAME ;' FROM dba_objects where owner='OWNER_NAME'and object_type = 'PACKAGE'
No comments:
Post a Comment