Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select 'GRANT '||PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME||' TO X_SCHM;' FROM DBA_TAB_PRIVS WHERE GRANTEE = 'APPS';
- select REFERENCED_OWNER, REFERENCED_TYPE, REFERENCED_NAME from dba_dependencies where NAME = 'HR_EMPLOYEE_API';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement