View Oracle Predefined Attribute Sets

Oracle predefined attribute sets can be used just like custom attribute sets.

Admin users set: A set of automatically identified admin users in any database based on the latest successful user assessment job. A user is added to this set if they are a database user that is granted (directly or indirectly) any privilege from the below list. The privilege must be either an administrative privilege or a system privilege. Administrative privileges are privileges listed in v$pwfile_users. System privileges are privileges assigned in dba_sys_privs.

Privileges that when granted cause a user to be added to the admin users set:

ADMINISTER ANY SQL TUNING SET, ADMINISTER DATABASE TRIGGER, ADMINISTER KEY MANAGEMENT, ADMINISTER
RESOURCE MANAGER, ADMINISTER SQL MANAGEMENT OBJECT , ADMINISTER SQL TUNING SET, ADVISOR, ALTER ANY
ANALYTIC VIEW, ALTER ANY ASSEMBLY, ALTER ANY ATTRIBUTE DIMENSION, ALTER ANY CLUSTER, ALTER ANY CUBE, ALTER
ANY CUBE BUILD PROCESS, ALTER ANY CUBE DIMENSION, ALTER ANY DIMENSION, ALTER ANY EDITION, ALTER ANY
EVALUATION CONTEXT, ALTER ANY HIERARCHY, ALTER ANY INDEX, ALTER ANY INDEXTYPE, ALTER ANY LIBRARY, ALTER ANY
MATERIALIZED VIEW, ALTER ANY MEASURE FOLDER, ALTER ANY MINING MODEL, ALTER ANY OPERATOR, ALTER ANY
OUTLINE, ALTER ANY PROCEDURE, ALTER ANY ROLE, ALTER ANY RULE, ALTER ANY RULE SET, ALTER ANY SEQUENCE, ALTER
ANY SQL PROFILE, ALTER ANY SQL TRANSLATION PROFILE, ALTER ANY TABLE, ALTER ANY TRIGGER, ALTER ANY TYPE, ALTER
DATABASE, ALTER DATABASE LINK, ALTER LOCKDOWN PROFILE, ALTER PROFILE, ALTER PUBLIC DATABASE LINK, ALTER
RESOURCE COST, ALTER ROLLBACK SEGMENT, ALTER SESSION, ALTER SYSTEM, ALTER TABLESPACE, ALTER USER,
ANALYZE ANY, ANALYZE ANY DICTIONARY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY
MINING MODEL, COMMENT ANY TABLE, CREATE ANY ANALYTIC VIEW, CREATE ANY ASSEMBLY, CREATE ANY ATTRIBUTE
DIMENSION, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CREDENTIAL, CREATE ANY CUBE, CREATE ANY
CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY
EDITION, CREATE ANY EVALUATION CONTEXT, CREATE ANY HIERARCHY, CREATE ANY INDEX, CREATE ANY INDEXTYPE,
CREATE ANY JOB, CREATE ANY LIBRARY, CREATE ANY MATERIALIZED VIEW, CREATE ANY MEASURE FOLDER, CREATE ANY
MINING MODEL, CREATE ANY OPERATOR, CREATE ANY OUTLINE, CREATE ANY PROCEDURE, CREATE ANY RULE, CREATE ANY
RULE SET, CREATE ANY SEQUENCE, CREATE ANY SQL PROFILE, CREATE ANY SQL TRANSLATION PROFILE, CREATE ANY
SYNONYM, CREATE ANY TABLE, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW, CREATE CLUSTER, CREATE
DATABASE LINK, CREATE EXTERNAL JOB, CREATE LIBRARY, CREATE LOCKDOWN PROFILE, CREATE PLUGGABLE DATABASE,
CREATE PROFILE, CREATE PUBLIC DATABASE LINK, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE ROLLBACK SEGMENT,
CREATE SQL TRANSLATION PROFILE, CREATE SYNONYM, CREATE TABLESPACE, CREATE USER, DEBUG ANY PROCEDURE,
DEBUG CONNECT ANY, DELETE ANY CUBE DIMENSION, DELETE ANY MEASURE FOLDER, DELETE ANY TABLE, DEQUEUE ANY
QUEUE, DROP ANY ANALYTIC VIEW, DROP ANY ASSEMBLY, DROP ANY ATTRIBUTE DIMENSION, DROP ANY CLUSTER, DROP
ANY CONTEXT, DROP ANY CUBE, DROP ANY CUBE BUILD PROCESS, DROP ANY CUBE DIMENSION, DROP ANY DIMENSION,
DROP ANY DIRECTORY, DROP ANY EDITION, DROP ANY EVALUATION CONTEXT, DROP ANY HIERARCHY, DROP ANY INDEX,
DROP ANY INDEXTYPE, DROP ANY LIBRARY, DROP ANY MATERIALIZED VIEW, DROP ANY MEASURE FOLDER, DROP ANY
MINING MODEL, DROP ANY OPERATOR, DROP ANY OUTLINE, DROP ANY PROCEDURE, DROP ANY ROLE, DROP ANY RULE,
DROP ANY RULE SET, DROP ANY SEQUENCE, DROP ANY SQL PROFILE, DROP ANY SQL TRANSLATION PROFILE , DROP ANY
SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP LOCKDOWN PROFILE, DROP
PROFILE, DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT, DROP TABLESPACE, DROP
USER, ENQUEUE ANY QUEUE, EXECUTE ANY ASSEMBLY, EXECUTE ANY CLASS, EXECUTE ANY EVALUATION CONTEXT,
EXECUTE ANY INDEXTYPE, EXECUTE ANY LIBRARY, EXECUTE ANY OPERATOR, EXECUTE ANY PROCEDURE, EXECUTE ANY
PROGRAM, EXECUTE ANY RULE, EXECUTE ANY RULE SET, EXECUTE ANY TYPE, EXEMPT ACCESS POLICY, EXEMPT DDL
REDACTION POLICY, EXEMPT DML REDACTION POLICY, EXEMPT IDENTITY POLICY, EXEMPT REDACTION POLICY, EXPORT
FULL DATABASE, FLASHBACK ANY TABLE, FLASHBACK ARCHIVE ADMINISTER, FORCE ANY TRANSACTION, GLOBAL QUERY
REWRITE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE, GRANT ANY ROLE, IMPORT FULL DATABASE, INHERIT ANY
PRIVILEGES, INHERIT ANY REMOTE PRIVILEGES, INSERT ANY CUBE DIMENSION, INSERT ANY MEASURE FOLDER, INSERT ANY
TABLE, LOCK ANY TABLE, LOGMINING, MANAGE ANY FILE GROUP, MANAGE ANY QUEUE, MANAGE FILE GROUP, MANAGE
SCHEDULER, MANAGE TABLESPACE, MERGE ANY VIEW, PURGE DBA_RECYCLEBIN, READ ANY FILE GROUP, READ ANY TABLE,
REDEFINE ANY TABLE, RESTRICTED SESSION, SELECT ANY CUBE, SELECT ANY CUBE BUILD PROCESS, SELECT ANY CUBE
DIMENSION, SELECT ANY DICTIONARY, SELECT ANY MEASURE FOLDER, SELECT ANY MINING MODEL, SELECT ANY
SEQUENCE, SELECT ANY TABLE, SELECT ANY TRANSACTION, TRANSLATE ANY SQL, UNDER ANY TABLE, UNDER ANY TYPE,
UNDER ANY VIEW, UPDATE ANY CUBE, UPDATE ANY CUBE BUILD PROCESS, UPDATE ANY CUBE DIMENSION, UPDATE ANY
TABLE, USE ANY JOB RESOURCE, USE ANY SQL TRANSLATION PROFILE

System privilege that restrict the user to actions within the user's schema or user's session do not cause a user to be added to the admin user set. Therefore, users with the below privileges are excluded from the admin user set:

CREATE TABLE, CREATE JOB, EM EXPRESS CONNECT, CREATE MATERIALIZED VIEW, RESUMABLE, 
CREATE ASSEMBLY, CREATE CUBE DIMENSION, ON COMMIT REFRESH, EXECUTE ASSEMBLY, CREATE RULE
SET, CREATE VIEW, CREATE CREDENTIAL, CREATE OPERATOR, CREATE CUBE BUILD PROCESS, FORCE TRANSACTION, 
CREATE TYPE, QUERY REWRITE, CHANGE NOTIFICATION, DEBUG CONNECT SESSION, CREATE
DIMENSION, CREATE MINING MODEL, CREATE SESSION, CREATE TRIGGER, CREATE EVALUATION CONTEXT,
CREATE RULE, CREATE MEASURE FOLDER, CREATE PROCEDURE, CREATE SEQUENCE, CREATE DATABASE LINK, CREATE
CUBE, CREATE INDEXTYPE, UNLIMITED TABLESPACE, CREATE CLUSTER, CREATE ANALYTIC VIEW, CREATE ATTRIBUTE
DIMENSION, CREATE HIERARCHY, SET CONTAINER, KEEP DATE TIME, KEEP SYSGUID.