Wednesday, January 21, 2009

Generate Script To Grant Select Privileg To User On All Tables

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: