Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT PRIVILEGE
- FROM ALL_TAB_PRIVS_RECD
- WHERE PRIVILEGE = 'SELECT'
- AND TABLE_NAME = 'GN_VERSION'
- AND OWNER = 'USER_A'
- UNION ALL
- SELECT PRIVILEGE
- FROM SESSION_PRIVS
- WHERE PRIVILEGE = 'SELECT ANY TABLE';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement