×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Apr 11, 2018 3:43 PM
Views: 2
Tags: no tags
  1. SELECT
  2.   DBA_TAB_PRIVS.GRANTEE,
  3.   TABLE_NAME,
  4.   PRIVILEGE,
  5.   DBA_ROLE_PRIVS.GRANTEE
  6. FROM DBA_TAB_PRIVS, DBA_ROLE_PRIVS
  7. WHERE DBA_TAB_PRIVS.GRANTEE = DBA_ROLE_PRIVS.GRANTED_ROLE
  8.       AND DBA_TAB_PRIVS.GRANTEE IN (
  9.   'RESOURCE',
  10.   'SENIOR_BIO',
  11.   'SQLT_USER_ROLE',
  12.   'ZARGOS_Q_ROLE'
  13. ) --= '<ENTER GROUP ROLE HERE>'
  14.       AND DBA_ROLE_PRIVS.GRANTEE = 'UTL_D_PP'
  15. --   AND DBA_TAB_PRIVS.GRANTEE <> 'ZARGOS_Q_ROLE'
  16. ORDER BY DBA_ROLE_PRIVS.GRANTEE