Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Join dba_users, dba_sys_privs

SQL> SQL> SET FEEDBACK OFF SQL> SET PAGESIZE 20 SQL> SET LINESIZE 77 SQL> SET HEADING ON SQL> SQL> COLUMN username FORMAT A12 HEADING 'User' SQL> COLUMN privilege FORMAT A20 HEADING 'Privilege' SQL> TTITLE LEFT 'User System Privileges' RIGHT 'Page ' FORMAT 999 SQL.PNO SKIP 2 SQL> SQL> SELECT username, privilege   2  FROM dba_users, dba_sys_privs   3  WHERE username = grantee   4  ORDER BY username, privilege; User System Privileges                                              Page    1 User         Privilege ------------ -------------------- ANONYMOUS    CREATE SESSION CTXSYS       ALTER SESSION CTXSYS       CREATE PUBLIC SYNONY              M CTXSYS       CREATE SESSION CTXSYS       CREATE SYNONYM CTXSYS       CREATE VIEW CTXSYS       DROP PUBLIC SYNONYM CTXSYS       UNLIMITED TABLESPACE DBSNMP       CREATE PROCEDURE DBSNMP       CREATE TABLE DBSNMP       SELECT ANY DICTIONAR              Y User System Privileges                                              Page    2 User         Privilege ------------ -------------------- DBSNMP       UNLIMITED TABLESPACE DEFINER      UNLIMITED TABLESPACE DIP          CREATE SESSION FLOWS_020100 ALTER DATABASE FLOWS_020100 ALTER SESSION FLOWS_020100 ALTER SYSTEM FLOWS_020100 ALTER USER FLOWS_020100 CREATE ANY CONTEXT FLOWS_020100 CREATE ANY DIRECTORY FLOWS_020100 CREATE CLUSTER FLOWS_020100 CREATE DATABASE LINK FLOWS_020100 CREATE DIMENSION FLOWS_020100 CREATE INDEXTYPE FLOWS_020100 CREATE JOB FLOWS_020100 CREATE LIBRARY User System Privileges                                              Page    3 User         Privilege ------------ -------------------- FLOWS_020100 CREATE MATERIALIZED              VIEW FLOWS_020100 CREATE OPERATOR FLOWS_020100 CREATE PROCEDURE FLOWS_020100 CREATE PUBLIC SYNONY              M FLOWS_020100 CREATE ROLE FLOWS_020100 CREATE SEQUENCE SQL> SET FEEDBACK ON SQL>