SELECT 'GRANT SELECT ON schema name.'|| table_name||' to user name ;' FROM dba_tables WHERE owner = 'owner name' ;
SELECT 'GRANT SELECT ON schema name.'|| view_name||' to user name ;' FROM dba_views WHERE owner = 'owner name' ;
SELECT 'grant EXECUTE ON schema name.'||object_name||' to user name ;'
FROM dba_objects WHERE owner='owner name' and OBJECT_TYPE in ('FUNCTION' ,'PROCEDURE') ;
No comments:
Post a Comment