Oracle Database

Oracle Database User Privilege Listelemek

Oracle Database üzerinde hangi kullacının hangi yetkilere sahip olduğunu listemek isterseniz aşağıdaki sorguyu kullanabilirsiniz.

SELECT A.*, 'GRANTED TO USER' TYPE
  FROM DBA_SYS_PRIVS A, DBA_USERS B
 WHERE     A.GRANTEE = B.USERNAME
       AND GRANTEE NOT IN ('ANONYMOUS',
                           'CTXSYS',
                           'DBSNMP',
                           'EXFSYS',
                           'LBACSYS',
                           'MDSYS',
                           'MGMT_VIEW',
                           'OLAPSYS',
                           'OWBSYS',
                           'ORDPLUGINS',
                           'ORDSYS',
                           'OUTLN',
                           'SI_INFORMTN_SCHEMA',
                           'SYS',
                           'SYSMAN',
                           'SYSTEM',
                           'TSMSYS',
                           'WK_TEST',
                           'WKSYS',
                           'WKPROXY',
                           'WMSYS',
                           'XDB',
                           'APEX_PUBLIC_USER',
                           'DIP',
                           'FLOWS_30000',
                           'FLOWS_FILES',
                           'MDDATA',
                           'ORACLE_OCM',
                           'SPATIAL_CSW_ADMIN_USR',
                           'SPATIAL_WFS_ADMIN_USR',
                           'XS$NULL',
                           'OWBSYS_AUDIT',
                           'ORDDATA',
                           'APEX_030200',
                           'APPQOSSYS',
                           'DVSYS',
                           'DVF')

Tags

Bugra Parlayan

I use this blog in my spare time to jot down thoughts and share my professional experiences. It’s my personal space to unwind and reflect. Feel free to share or reuse anything you find helpful here — just a small thank you is more than enough :) You can reach me at: bugra[@]bugraparlayan.com.tr

Related Articles

Back to top button
Close