Advertisement
Guest User

Untitled

a guest
Dec 17th, 2014
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT PRIVILEGE
  2. FROM ALL_TAB_PRIVS_RECD
  3. WHERE PRIVILEGE = 'SELECT'
  4. AND TABLE_NAME = 'GN_VERSION'
  5. AND OWNER = 'USER_A'
  6. UNION ALL
  7. SELECT PRIVILEGE
  8. FROM SESSION_PRIVS
  9. WHERE PRIVILEGE = 'SELECT ANY TABLE';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement