6 Replies Latest reply: Nov 28, 2012 6:18 AM by Richard Harrison . RSS

    output of system_privilege_map for version 10g needed

    975484
      Hello everyone.

      I need the output of system_privilege_map for Oracle DB version 10g because i've no access to a 10g db at the moment but i need the complete list of the system privileges with 173 entries.

      Hope someone of you will be such nice and post it here for me :-)

      Thanks in advance.
      Jim
        • 1. Re: output of system_privilege_map for version 10g needed
          Osama_Mustafa
          NAME
          ----------------------------------------
          FLASHBACK ARCHIVE ADMINISTER
          ALTER DATABASE LINK
          ALTER PUBLIC DATABASE LINK
          ADMINISTER SQL MANAGEMENT OBJECT
          UPDATE ANY CUBE DIMENSION
          UPDATE ANY CUBE BUILD PROCESS
          DROP ANY CUBE BUILD PROCESS
          CREATE ANY CUBE BUILD PROCESS
          CREATE CUBE BUILD PROCESS
          INSERT ANY MEASURE FOLDER
          DROP ANY MEASURE FOLDER
          
          NAME
          ----------------------------------------
          DELETE ANY MEASURE FOLDER
          CREATE ANY MEASURE FOLDER
          CREATE MEASURE FOLDER
          UPDATE ANY CUBE
          SELECT ANY CUBE
          DROP ANY CUBE
          CREATE ANY CUBE
          ALTER ANY CUBE
          CREATE CUBE
          SELECT ANY CUBE DIMENSION
          INSERT ANY CUBE DIMENSION
          
          NAME
          ----------------------------------------
          DROP ANY CUBE DIMENSION
          DELETE ANY CUBE DIMENSION
          CREATE ANY CUBE DIMENSION
          ALTER ANY CUBE DIMENSION
          CREATE CUBE DIMENSION
          COMMENT ANY MINING MODEL
          ALTER ANY MINING MODEL
          SELECT ANY MINING MODEL
          DROP ANY MINING MODEL
          CREATE ANY MINING MODEL
          CREATE MINING MODEL
          
          NAME
          ----------------------------------------
          EXECUTE ASSEMBLY
          EXECUTE ANY ASSEMBLY
          DROP ANY ASSEMBLY
          ALTER ANY ASSEMBLY
          CREATE ANY ASSEMBLY
          CREATE ASSEMBLY
          ALTER ANY EDITION
          DROP ANY EDITION
          CREATE ANY EDITION
          CREATE EXTERNAL JOB
          CHANGE NOTIFICATION
          
          NAME
          ----------------------------------------
          READ ANY FILE GROUP
          MANAGE ANY FILE GROUP
          MANAGE FILE GROUP
          EXEMPT IDENTITY POLICY
          CREATE ANY SQL PROFILE
          ADMINISTER ANY SQL TUNING SET
          ADMINISTER SQL TUNING SET
          ALTER ANY SQL PROFILE
          DROP ANY SQL PROFILE
          SELECT ANY TRANSACTION
          MANAGE SCHEDULER
          
          NAME
          ----------------------------------------
          EXECUTE ANY CLASS
          EXECUTE ANY PROGRAM
          CREATE ANY JOB
          CREATE JOB
          ADVISOR
          ANALYZE ANY DICTIONARY
          EXECUTE ANY RULE
          DROP ANY RULE
          ALTER ANY RULE
          CREATE ANY RULE
          CREATE RULE
          
          NAME
          ----------------------------------------
          IMPORT FULL DATABASE
          EXPORT FULL DATABASE
          EXECUTE ANY RULE SET
          DROP ANY RULE SET
          ALTER ANY RULE SET
          CREATE ANY RULE SET
          CREATE RULE SET
          EXECUTE ANY EVALUATION CONTEXT
          DROP ANY EVALUATION CONTEXT
          ALTER ANY EVALUATION CONTEXT
          CREATE ANY EVALUATION CONTEXT
          
          NAME
          ----------------------------------------
          CREATE EVALUATION CONTEXT
          GRANT ANY OBJECT PRIVILEGE
          FLASHBACK ANY TABLE
          DEBUG ANY PROCEDURE
          DEBUG CONNECT SESSION
          SELECT ANY DICTIONARY
          RESUMABLE
          EXEMPT ACCESS POLICY
          ON COMMIT REFRESH
          MERGE ANY VIEW
          ADMINISTER DATABASE TRIGGER
          
          NAME
          ----------------------------------------
          ADMINISTER RESOURCE MANAGER
          DROP ANY OUTLINE
          ALTER ANY OUTLINE
          CREATE ANY OUTLINE
          DROP ANY CONTEXT
          CREATE ANY CONTEXT
          DEQUEUE ANY QUEUE
          ENQUEUE ANY QUEUE
          MANAGE ANY QUEUE
          DROP ANY DIMENSION
          ALTER ANY DIMENSION
          
          NAME
          ----------------------------------------
          CREATE ANY DIMENSION
          CREATE DIMENSION
          UNDER ANY TABLE
          EXECUTE ANY INDEXTYPE
          GLOBAL QUERY REWRITE
          QUERY REWRITE
          UNDER ANY VIEW
          DROP ANY INDEXTYPE
          ALTER ANY INDEXTYPE
          CREATE ANY INDEXTYPE
          CREATE INDEXTYPE
          
          NAME
          ----------------------------------------
          EXECUTE ANY OPERATOR
          DROP ANY OPERATOR
          ALTER ANY OPERATOR
          CREATE ANY OPERATOR
          CREATE OPERATOR
          EXECUTE ANY LIBRARY
          DROP ANY LIBRARY
          ALTER ANY LIBRARY
          CREATE ANY LIBRARY
          CREATE LIBRARY
          UNDER ANY TYPE
          
          NAME
          ----------------------------------------
          EXECUTE ANY TYPE
          DROP ANY TYPE
          ALTER ANY TYPE
          CREATE ANY TYPE
          CREATE TYPE
          DROP ANY DIRECTORY
          CREATE ANY DIRECTORY
          DROP ANY MATERIALIZED VIEW
          ALTER ANY MATERIALIZED VIEW
          CREATE ANY MATERIALIZED VIEW
          CREATE MATERIALIZED VIEW
          
          NAME
          ----------------------------------------
          GRANT ANY PRIVILEGE
          ANALYZE ANY
          ALTER RESOURCE COST
          DROP PROFILE
          ALTER PROFILE
          CREATE PROFILE
          DROP ANY TRIGGER
          ALTER ANY TRIGGER
          CREATE ANY TRIGGER
          CREATE TRIGGER
          EXECUTE ANY PROCEDURE
          
          NAME
          ----------------------------------------
          DROP ANY PROCEDURE
          ALTER ANY PROCEDURE
          CREATE ANY PROCEDURE
          CREATE PROCEDURE
          FORCE ANY TRANSACTION
          FORCE TRANSACTION
          ALTER DATABASE
          AUDIT ANY
          ALTER ANY ROLE
          GRANT ANY ROLE
          DROP ANY ROLE
          
          NAME
          ----------------------------------------
          CREATE ROLE
          DROP PUBLIC DATABASE LINK
          CREATE PUBLIC DATABASE LINK
          CREATE DATABASE LINK
          SELECT ANY SEQUENCE
          DROP ANY SEQUENCE
          ALTER ANY SEQUENCE
          CREATE ANY SEQUENCE
          CREATE SEQUENCE
          DROP ANY VIEW
          CREATE ANY VIEW
          
          NAME
          ----------------------------------------
          CREATE VIEW
          DROP PUBLIC SYNONYM
          CREATE PUBLIC SYNONYM
          SYSOPER
          SYSDBA
          DROP ANY SYNONYM
          CREATE ANY SYNONYM
          CREATE SYNONYM
          DROP ANY INDEX
          ALTER ANY INDEX
          CREATE ANY INDEX
          
          NAME
          ----------------------------------------
          DROP ANY CLUSTER
          ALTER ANY CLUSTER
          CREATE ANY CLUSTER
          CREATE CLUSTER
          DELETE ANY TABLE
          UPDATE ANY TABLE
          INSERT ANY TABLE
          SELECT ANY TABLE
          COMMENT ANY TABLE
          LOCK ANY TABLE
          DROP ANY TABLE
          
          NAME
          ----------------------------------------
          BACKUP ANY TABLE
          ALTER ANY TABLE
          CREATE ANY TABLE
          CREATE TABLE
          DROP ROLLBACK SEGMENT
          ALTER ROLLBACK SEGMENT
          CREATE ROLLBACK SEGMENT
          DROP USER
          ALTER USER
          BECOME USER
          CREATE USER
          
          NAME
          ----------------------------------------
          UNLIMITED TABLESPACE
          DROP TABLESPACE
          MANAGE TABLESPACE
          ALTER TABLESPACE
          CREATE TABLESPACE
          RESTRICTED SESSION
          ALTER SESSION
          CREATE SESSION
          AUDIT SYSTEM
          ALTER SYSTEM
          
          208 rows selected.
          • 2. Re: output of system_privilege_map for version 10g needed
            975484
            Thanks you very much but at all i count 208(!) rows but as far as i know there are only 173 rows in version 10g. Please correct me if i'm wrong.
            Jim
            • 3. Re: output of system_privilege_map for version 10g needed
              Osama_Mustafa
              The above for 11g But now the below for 10g
              SQL> select name from system_privilege_map; 
              
              NAME
              ----------------------------------------
              CREATE EXTERNAL JOB
              CHANGE NOTIFICATION
              READ ANY FILE GROUP
              MANAGE ANY FILE GROUP
              MANAGE FILE GROUP
              EXEMPT IDENTITY POLICY
              CREATE ANY SQL PROFILE
              ADMINISTER ANY SQL TUNING SET
              ADMINISTER SQL TUNING SET
              ALTER ANY SQL PROFILE
              DROP ANY SQL PROFILE
              
              NAME
              ----------------------------------------
              SELECT ANY TRANSACTION
              MANAGE SCHEDULER
              EXECUTE ANY CLASS
              EXECUTE ANY PROGRAM
              CREATE ANY JOB
              CREATE JOB
              ADVISOR
              ANALYZE ANY DICTIONARY
              EXECUTE ANY RULE
              DROP ANY RULE
              ALTER ANY RULE
              
              NAME
              ----------------------------------------
              CREATE ANY RULE
              CREATE RULE
              IMPORT FULL DATABASE
              EXPORT FULL DATABASE
              EXECUTE ANY RULE SET
              DROP ANY RULE SET
              ALTER ANY RULE SET
              CREATE ANY RULE SET
              CREATE RULE SET
              EXECUTE ANY EVALUATION CONTEXT
              DROP ANY EVALUATION CONTEXT
              
              NAME
              ----------------------------------------
              ALTER ANY EVALUATION CONTEXT
              CREATE ANY EVALUATION CONTEXT
              CREATE EVALUATION CONTEXT
              GRANT ANY OBJECT PRIVILEGE
              FLASHBACK ANY TABLE
              DEBUG ANY PROCEDURE
              DEBUG CONNECT SESSION
              SELECT ANY DICTIONARY
              RESUMABLE
              EXEMPT ACCESS POLICY
              ON COMMIT REFRESH
              
              NAME
              ----------------------------------------
              MERGE ANY VIEW
              ADMINISTER DATABASE TRIGGER
              ADMINISTER RESOURCE MANAGER
              DROP ANY OUTLINE
              ALTER ANY OUTLINE
              CREATE ANY OUTLINE
              DROP ANY CONTEXT
              CREATE ANY CONTEXT
              DEQUEUE ANY QUEUE
              ENQUEUE ANY QUEUE
              MANAGE ANY QUEUE
              
              NAME
              ----------------------------------------
              DROP ANY DIMENSION
              ALTER ANY DIMENSION
              CREATE ANY DIMENSION
              CREATE DIMENSION
              UNDER ANY TABLE
              EXECUTE ANY INDEXTYPE
              GLOBAL QUERY REWRITE
              QUERY REWRITE
              UNDER ANY VIEW
              DROP ANY INDEXTYPE
              ALTER ANY INDEXTYPE
              
              NAME
              ----------------------------------------
              CREATE ANY INDEXTYPE
              CREATE INDEXTYPE
              EXECUTE ANY OPERATOR
              DROP ANY OPERATOR
              ALTER ANY OPERATOR
              CREATE ANY OPERATOR
              CREATE OPERATOR
              EXECUTE ANY LIBRARY
              DROP ANY LIBRARY
              ALTER ANY LIBRARY
              CREATE ANY LIBRARY
              
              NAME
              ----------------------------------------
              CREATE LIBRARY
              UNDER ANY TYPE
              EXECUTE ANY TYPE
              DROP ANY TYPE
              ALTER ANY TYPE
              CREATE ANY TYPE
              CREATE TYPE
              DROP ANY DIRECTORY
              CREATE ANY DIRECTORY
              DROP ANY MATERIALIZED VIEW
              ALTER ANY MATERIALIZED VIEW
              
              NAME
              ----------------------------------------
              CREATE ANY MATERIALIZED VIEW
              CREATE MATERIALIZED VIEW
              GRANT ANY PRIVILEGE
              ANALYZE ANY
              ALTER RESOURCE COST
              DROP PROFILE
              ALTER PROFILE
              CREATE PROFILE
              DROP ANY TRIGGER
              ALTER ANY TRIGGER
              CREATE ANY TRIGGER
              
              NAME
              ----------------------------------------
              CREATE TRIGGER
              EXECUTE ANY PROCEDURE
              DROP ANY PROCEDURE
              ALTER ANY PROCEDURE
              CREATE ANY PROCEDURE
              CREATE PROCEDURE
              FORCE ANY TRANSACTION
              FORCE TRANSACTION
              ALTER DATABASE
              AUDIT ANY
              ALTER ANY ROLE
              
              NAME
              ----------------------------------------
              GRANT ANY ROLE
              DROP ANY ROLE
              CREATE ROLE
              DROP PUBLIC DATABASE LINK
              CREATE PUBLIC DATABASE LINK
              CREATE DATABASE LINK
              SELECT ANY SEQUENCE
              DROP ANY SEQUENCE
              ALTER ANY SEQUENCE
              CREATE ANY SEQUENCE
              CREATE SEQUENCE
              
              NAME
              ----------------------------------------
              DROP ANY VIEW
              CREATE ANY VIEW
              CREATE VIEW
              DROP PUBLIC SYNONYM
              CREATE PUBLIC SYNONYM
              SYSOPER
              SYSDBA
              DROP ANY SYNONYM
              CREATE ANY SYNONYM
              CREATE SYNONYM
              DROP ANY INDEX
              
              NAME
              ----------------------------------------
              ALTER ANY INDEX
              CREATE ANY INDEX
              DROP ANY CLUSTER
              ALTER ANY CLUSTER
              CREATE ANY CLUSTER
              CREATE CLUSTER
              DELETE ANY TABLE
              UPDATE ANY TABLE
              INSERT ANY TABLE
              SELECT ANY TABLE
              COMMENT ANY TABLE
              
              NAME
              ----------------------------------------
              LOCK ANY TABLE
              DROP ANY TABLE
              BACKUP ANY TABLE
              ALTER ANY TABLE
              CREATE ANY TABLE
              CREATE TABLE
              DROP ROLLBACK SEGMENT
              ALTER ROLLBACK SEGMENT
              CREATE ROLLBACK SEGMENT
              DROP USER
              ALTER USER
              
              NAME
              ----------------------------------------
              BECOME USER
              CREATE USER
              UNLIMITED TABLESPACE
              DROP TABLESPACE
              MANAGE TABLESPACE
              ALTER TABLESPACE
              CREATE TABLESPACE
              RESTRICTED SESSION
              ALTER SESSION
              CREATE SESSION
              AUDIT SYSTEM
              
              NAME
              ----------------------------------------
              ALTER SYSTEM
              • 4. Re: output of system_privilege_map for version 10g needed
                975484
                Thanks for your posting but....

                Isn't it so that following versions has following number of entries of system privileges ?!

                9.2/91 = 157
                10g = 173
                11g = 166

                But upper 10g post has 166 entries and this is a version 11g ?

                As mentioned before - please correct me if i'm wrong.
                Also i'm interested if updates will add more system privileges to the db!?

                thanks, Jim
                • 6. Re: output of system_privilege_map for version 10g needed
                  Richard Harrison .
                  Hi,
                  In 10.2.0.3 i get 166 entries - confirmed with what exists in sql.bsq

                  grep SYSTEM_PRIVILEGE_MAP sql.bsq |grep -i insert |grep -v rem |wc -l
                  =166

                  SQL> /
                  -3 ALTER SYSTEM 0
                  -4 AUDIT SYSTEM 0
                  -5 CREATE SESSION 0
                  -6 ALTER SESSION 0
                  -7 RESTRICTED SESSION 0
                  -10 CREATE TABLESPACE 0
                  -11 ALTER TABLESPACE 0
                  -12 MANAGE TABLESPACE 0
                  -13 DROP TABLESPACE 0
                  -15 UNLIMITED TABLESPACE 0
                  -20 CREATE USER 0
                  -21 BECOME USER 0
                  -22 ALTER USER 0
                  -23 DROP USER 0
                  -30 CREATE ROLLBACK SEGMENT 0
                  -31 ALTER ROLLBACK SEGMENT 0
                  -32 DROP ROLLBACK SEGMENT 0
                  -40 CREATE TABLE 0
                  -41 CREATE ANY TABLE 0
                  -42 ALTER ANY TABLE 0
                  -43 BACKUP ANY TABLE 0
                  -44 DROP ANY TABLE 0
                  -45 LOCK ANY TABLE 0
                  -46 COMMENT ANY TABLE 0
                  -47 SELECT ANY TABLE 0
                  -48 INSERT ANY TABLE 0
                  -49 UPDATE ANY TABLE 0
                  -50 DELETE ANY TABLE 0
                  -60 CREATE CLUSTER 0
                  -61 CREATE ANY CLUSTER 0
                  -62 ALTER ANY CLUSTER 0
                  -63 DROP ANY CLUSTER 0
                  -71 CREATE ANY INDEX 0
                  -72 ALTER ANY INDEX 0
                  -73 DROP ANY INDEX 0
                  -80 CREATE SYNONYM 0
                  -81 CREATE ANY SYNONYM 0
                  -82 DROP ANY SYNONYM 0
                  -83 SYSDBA 0
                  -84 SYSOPER 0
                  -85 CREATE PUBLIC SYNONYM 0
                  -86 DROP PUBLIC SYNONYM 0
                  -90 CREATE VIEW 0
                  -91 CREATE ANY VIEW 0
                  -92 DROP ANY VIEW 0
                  -105 CREATE SEQUENCE 0
                  -106 CREATE ANY SEQUENCE 0
                  -107 ALTER ANY SEQUENCE 0
                  -108 DROP ANY SEQUENCE 0
                  -109 SELECT ANY SEQUENCE 0
                  -115 CREATE DATABASE LINK 0
                  -120 CREATE PUBLIC DATABASE LINK 0
                  -121 DROP PUBLIC DATABASE LINK 0
                  -125 CREATE ROLE 0
                  -126 DROP ANY ROLE 0
                  -127 GRANT ANY ROLE 0
                  -128 ALTER ANY ROLE 0
                  -130 AUDIT ANY 0
                  -135 ALTER DATABASE 0
                  -138 FORCE TRANSACTION 0
                  -139 FORCE ANY TRANSACTION 0
                  -140 CREATE PROCEDURE 0
                  -141 CREATE ANY PROCEDURE 0
                  -142 ALTER ANY PROCEDURE 0
                  -143 DROP ANY PROCEDURE 0
                  -144 EXECUTE ANY PROCEDURE 0
                  -151 CREATE TRIGGER 0
                  -152 CREATE ANY TRIGGER 0
                  -153 ALTER ANY TRIGGER 0
                  -154 DROP ANY TRIGGER 0
                  -160 CREATE PROFILE 0
                  -161 ALTER PROFILE 0
                  -162 DROP PROFILE 0
                  -163 ALTER RESOURCE COST 0
                  -165 ANALYZE ANY 0
                  -167 GRANT ANY PRIVILEGE 0
                  -172 CREATE MATERIALIZED VIEW 0
                  -173 CREATE ANY MATERIALIZED VIEW 0
                  -174 ALTER ANY MATERIALIZED VIEW 0
                  -175 DROP ANY MATERIALIZED VIEW 0
                  -177 CREATE ANY DIRECTORY 0
                  -178 DROP ANY DIRECTORY 0
                  -180 CREATE TYPE 0
                  -181 CREATE ANY TYPE 0
                  -182 ALTER ANY TYPE 0
                  -183 DROP ANY TYPE 0
                  -184 EXECUTE ANY TYPE 0
                  -186 UNDER ANY TYPE 0
                  -188 CREATE LIBRARY 0
                  -189 CREATE ANY LIBRARY 0
                  -190 ALTER ANY LIBRARY 0
                  -191 DROP ANY LIBRARY 0
                  -192 EXECUTE ANY LIBRARY 0
                  -200 CREATE OPERATOR 0
                  -201 CREATE ANY OPERATOR 0
                  -202 ALTER ANY OPERATOR 0
                  -203 DROP ANY OPERATOR 0
                  -204 EXECUTE ANY OPERATOR 0
                  -205 CREATE INDEXTYPE 0
                  -206 CREATE ANY INDEXTYPE 0
                  -207 ALTER ANY INDEXTYPE 0
                  -208 DROP ANY INDEXTYPE 0
                  -209 UNDER ANY VIEW 0
                  -210 QUERY REWRITE 0
                  -211 GLOBAL QUERY REWRITE 0
                  -212 EXECUTE ANY INDEXTYPE 0
                  -213 UNDER ANY TABLE 0
                  -214 CREATE DIMENSION 0
                  -215 CREATE ANY DIMENSION 0
                  -216 ALTER ANY DIMENSION 0
                  -217 DROP ANY DIMENSION 0
                  -218 MANAGE ANY QUEUE 1
                  -219 ENQUEUE ANY QUEUE 1
                  -220 DEQUEUE ANY QUEUE 1
                  -222 CREATE ANY CONTEXT 0
                  -223 DROP ANY CONTEXT 0
                  -224 CREATE ANY OUTLINE 0
                  -225 ALTER ANY OUTLINE 0
                  -226 DROP ANY OUTLINE 0
                  -227 ADMINISTER RESOURCE MANAGER 1
                  -228 ADMINISTER DATABASE TRIGGER 0
                  -233 MERGE ANY VIEW 0
                  -234 ON COMMIT REFRESH 0
                  -235 EXEMPT ACCESS POLICY 0
                  -236 RESUMABLE 0
                  -237 SELECT ANY DICTIONARY 0
                  -238 DEBUG CONNECT SESSION 0
                  -241 DEBUG ANY PROCEDURE 0
                  -243 FLASHBACK ANY TABLE 0
                  -244 GRANT ANY OBJECT PRIVILEGE 0
                  -245 CREATE EVALUATION CONTEXT 1
                  -246 CREATE ANY EVALUATION CONTEXT 1
                  -247 ALTER ANY EVALUATION CONTEXT 1
                  -248 DROP ANY EVALUATION CONTEXT 1
                  -249 EXECUTE ANY EVALUATION CONTEXT 1
                  -250 CREATE RULE SET 1
                  -251 CREATE ANY RULE SET 1
                  -252 ALTER ANY RULE SET 1
                  -253 DROP ANY RULE SET 1
                  -254 EXECUTE ANY RULE SET 1
                  -255 EXPORT FULL DATABASE 0
                  -256 IMPORT FULL DATABASE 0
                  -257 CREATE RULE 1
                  -258 CREATE ANY RULE 1
                  -259 ALTER ANY RULE 1
                  -260 DROP ANY RULE 1
                  -261 EXECUTE ANY RULE 1
                  -262 ANALYZE ANY DICTIONARY 0
                  -263 ADVISOR 0
                  -264 CREATE JOB 0
                  -265 CREATE ANY JOB 0
                  -266 EXECUTE ANY PROGRAM 0
                  -267 EXECUTE ANY CLASS 0
                  -268 MANAGE SCHEDULER 0
                  -269 SELECT ANY TRANSACTION 0
                  -270 DROP ANY SQL PROFILE 0
                  -271 ALTER ANY SQL PROFILE 0
                  -272 ADMINISTER SQL TUNING SET 0
                  -273 ADMINISTER ANY SQL TUNING SET 0
                  -274 CREATE ANY SQL PROFILE 0
                  -275 EXEMPT IDENTITY POLICY 0
                  -276 MANAGE FILE GROUP 1
                  -277 MANAGE ANY FILE GROUP 1
                  -278 READ ANY FILE GROUP 1
                  -279 CHANGE NOTIFICATION 0
                  -280 CREATE EXTERNAL JOB 0

                  166 rows selected.

                  In theory 10.2.0.4/10.2.0.5 could have altered this and 10.2.0.1 base version could be different from 10.2.0.3......

                  Cheers,
                  Harry