Grants and privileges for the PATROL database account
The following tables describe all the grants and privileges that are given to the PATROL database account when an instance is configured.
Warning
If you give additional grants (other than those mentioned in the table) to a PATROL database account and then revoke them, the product generates an event at the instance level similar to the following message in the PATROL Event Manager: BMCORACLEKM19E - Mon May 25 11:49:40 2009 - [OraDisInstObjectsExist() (/ORACLE)] Required privilege(s) missing, please reinstall PATROLDatabaseUser account on instanceName
The following table lists the grants given to a PATROL database account when a SYS account is specified.
PATROL account grants and privileges (SYS)
| Type of grant | Grant |
|---|---|
| Select | GRANT SELECT ON DBA_SCHEDULER_JOB_RUN_DETAILS |
| Select | GRANT SELECT ON V_$ASM_DISKGROUP_STAT |
| Create | GRANT CREATE SESSION |
| Create | GRANT CREATE TABLE |
| Create | GRANT CREATE SEQUENCE |
| Create | GRANT CREATE VIEW |
| Create | GRANT CREATE SYNONYM |
| Create | GRANT CREATE PUBLIC SYNONYM |
| Drop | GRANT DROP PUBLIC SYNONYM |
| Create | GRANT CREATE PROCEDURE |
| Select | GRANT SELECT ON V_$DATABASE_INCARNATION |
| Select | GRANT SELECT ON DBA_DB_LINKS |
| Select | GRANT SELECT ON DBA_TABLESPACES |
| Select | GRANT SELECT ON DBA_USERS |
| Select | GRANT SELECT ON DBA_TABLES |
| Select | GRANT SELECT ON DBA_INDEXES |
| Select | GRANT SELECT ON DBA_CLUSTERS |
| Select | GRANT SELECT ON DBA_CONSTRAINTS |
| Select | GRANT SELECT ON DBA_TAB_COLUMNS |
| Select | GRANT SELECT ON ROLE_TAB_PRIVS |
| Select | GRANT SELECT ON DBA_FREE_SPACE |
| Select | GRANT SELECT ON DBA_DATA_FILES |
| Select | GRANT SELECT ON DBA_TRIGGERS |
| Select | GRANT SELECT ON DBA_SEGMENTS |
| Select | GRANT SELECT ON DBA_SCHEDULER_JOBS |
| Select | GRANT SELECT ON DBA_OBJECTS |
| Select | GRANT SELECT ON DBA_OBJECTS |
| Select | GRANT SELECT ON DBA_ROLLBACK_SEGS |
| Select | GRANT SELECT ON DBA_UNDO_EXTENTS |
| Select | GRANT SELECT ON DBA_VIEWS |
| Select | GRANT SELECT ON V_$LATCH |
| Select | GRANT SELECT ON FET$ |
| Select | GRANT SELECT ON FILE$ |
| Select | GRANT SELECT ON SEG$ |
| Select | GRANT SELECT ON TS$ |
| Select | GRANT SELECT ON USER$ |
| Select | GRANT SELECT ON CCOL$ |
| Select | GRANT SELECT ON CDEF$ |
| Select | GRANT SELECT ON CLU$ |
| Select | GRANT SELECT ON COL$ |
| Select | GRANT SELECT ON IND$ |
| Select | GRANT SELECT ON OBJ$ |
| Select | GRANT SELECT ON TAB$ |
| Select | GRANT SELECT ON UET$ |
| Select | GRANT SELECT ON UNDO$ |
| Select | GRANT SELECT ON V$ROLLNAME |
| Select | GRANT SELECT ON V_$ACCESS |
| Select | GRANT SELECT ON V_$BACKUP |
| Select | GRANT SELECT ON V_$DATABASE |
| Select | GRANT SELECT ON V_$DATAFILE |
| Select | GRANT SELECT ON V_$DBFILE |
| Select | GRANT SELECT ON V_$DB_OBJECT_CACHE |
| Select | GRANT SELECT ON V_$DISPATCHER |
| Select | GRANT SELECT ON V_$FLASH_RECOVERY_AREA_USAGE |
| Select | GRANT SELECT ON V_$FILESTAT |
| Select | GRANT SELECT ON V_$LATCHNAME |
| Select | GRANT SELECT ON V_$LATCH_CHILDREN |
| Select | GRANT SELECT ON V_$LIBRARYCACHE |
| Select | GRANT SELECT ON V_$LICENSE |
| Select | GRANT SELECT ON V_$LOCK |
| Select | GRANT SELECT ON V_$LOGFILE |
| Select | GRANT SELECT ON V_$LOG_HISTORY |
| Select | GRANT SELECT ON V_$NLS_PARAMETERS |
| Select | GRANT SELECT ON V_$OPEN_CURSOR |
| Select | GRANT SELECT ON V_$PARAMETER |
| Select | GRANT SELECT ON V_$PROCESS |
| Select | GRANT SELECT ON V_$QUEUE |
| Select | GRANT SELECT ON V_$RECOVERY_LOG |
| Select | GRANT SELECT ON V_$RECOVERY_FILE_DEST |
| Select | GRANT SELECT ON V_$ROLLSTAT |
| Select | GRANT SELECT ON V_$ROLLNAME |
| Select | GRANT SELECT ON V_$ROWCACHE |
| Select | GRANT SELECT ON V_$SESSION |
| Select | GRANT SELECT ON V_$SESSION_WAIT |
| Select | GRANT SELECT ON V_$SESSTAT |
| Select | GRANT SELECT ON V_$SGASTAT |
| Select | GRANT SELECT ON V_$SHARED_SERVER |
| Select | GRANT SELECT ON V_$SHARED_POOL_RESERVED |
| Select | GRANT SELECT ON V_$SQL |
| Select | GRANT SELECT ON V_$SQLAREA |
| Select | GRANT SELECT ON V_$SQLTEXT |
| Select | GRANT SELECT ON V_$STATNAME |
| Select | GRANT SELECT ON V_$SYSSTAT |
| Select | GRANT SELECT ON V_$SYSTEM_EVENT |
| Select | GRANT SELECT ON V_$TIMER |
| Select | GRANT SELECT ON V_$TRANSACTION |
| Select | GRANT SELECT ON V_$VERSION |
| Select | GRANT SELECT ON V_$WAITSTAT |
| Select | GRANT SELECT ON V_$PQ_SLAVE |
| Select | GRANT SELECT ON V_$PQ_SESSTAT |
| Select | GRANT SELECT ON V_$PQ_SYSSTAT |
| Select | GRANT SELECT ON DBA_2PC_PENDING |
| Select | GRANT SELECT ON DBA_SNAPSHOTS |
| Select | GRANT SELECT ON DBA_ROLES |
| Select | GRANT SELECT ON DBA_COL_PRIVS |
| Select | GRANT SELECT ON DBA_TS_QUOTAS |
| Select | GRANT SELECT ON DBA_SYS_PRIVS |
| Select | GRANT SELECT ON DBA_ROLE_PRIVS |
| Select | GRANT SELECT ON DBA_JOBS |
| Select | GRANT SELECT ON V_$CONTROLFILE |
| Select | GRANT SELECT ON V_$RESOURCE_LIMIT |
| Select | GRANT SELECT ON DBA_FREE_SPACE_COALESCED |
| Select | GRANT SELECT ON V_$ARCHIVE_DEST_STATUS |
| Select | GRANT SELECT ON V_$DATABASE_INCARNATION |
| Select | GRANT SELECT ON DBA_SCHEDULER_JOBS |
| Select | GRANT SELECT ON DBA_PROFILES |
| Select | GRANT SELECT ON SYS.SYS_DBA_SEGS |
| Select | GRANT SELECT ON DBA_PART_TABLES |
| Select | GRANT SELECT ON DBA_TAB_PARTITIONS |
| Select | GRANT SELECT ON DBA_PART_INDEXES |
| Select | GRANT SELECT ON DBA_IND_PARTITIONS |
| Select | GRANT SELECT ON V_$SORT_SEGMENT |
| Select | GRANT SELECT ON V_$TEMP_EXTENT_POOL |
| Select | GRANT SELECT ON V_$TEMPSTAT |
| Select | GRANT SELECT ON V_$TEMPFILE |
| Select | GRANT SELECT ON V_$TABLESPACE |
| Select | GRANT SELECT ON DBA_TEMP_FILES |
| Select | GRANT SELECT ON V_$RECOVERY_FILE_DEST |
| Select | GRANT SELECT ON V_$ASM_DISKGROUP_STAT |
| Select | GRANT SELECT ON V_$FLASH_RECOVERY_AREA_USAGE |
| Select | GRANT SELECT ON V_$ARCHIVE_DEST |
| Select | GRANT SELECT ON V_INSTANCE |
| Select | GRANT SELECT ON FILEXT$ |
| Select | GRANT SELECT ON V_$LOG |
| Select | GRANT SELECT ON DBA_TAB_SUBPARTITIONS |
| Select | GRANT SELECT ON DBA_IND_SUBPARTITIONS |
| Select | GRANT SELECT ON V_$ARCHIVED_LOG |
| Select | GRANT SELECT ON SYS.USER$ |
| Select | GRANT SELECT ON DBA_PDBS |
| Select | GRANT SELECT ON CDB_DATA_FILES |
| Select | GRANT SELECT ON CDB_TABLESPACES |
| Select | GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS |
| Select | GRANT SELECT ON GV_$INSTANCE |
| Select | GRANT SELECT ON GV_$SESSION |
| Select | GRANT SELECT ON GV_$SESSION_WAIT |
| Select | GRANT SELECT ON GV_$SESSTAT |
| Select | GRANT SELECT ON GV_$LOCK |
| ALTER | GRANT ALTER ANY TABLE |
| ALTER | GRANT ALTER ANY INDEX |
| ALTER | GRANT ALTER ANY CLUSTER |
The following table lists the grants given to a PATROL database account when a NON-SYS DBA account is specified.
PATROL account grants and privileges (NON-SYS DBA)
Type of grant | Grant |
|---|---|
Create | GRANT CREATE SESSION |
Create | GRANT CREATE TABLE |
Create | GRANT CREATE SEQUENCE |
Create | GRANT CREATE VIEW |
Create | GRANT CREATE SYNONYM |
Create | GRANT CREATE PUBLIC SYNONYM |
Create | GRANT CREATE PROCEDURE |
Select | GRANT SELECT ANY DICTIONARY |
If rdbms_version>=12
| Type of grant | Grant |
|---|---|
| Select | GRANT SELECT ON SYS.USER$ |
| Select | GRANT SELECT ON DBA_PDBS |
| Select | GRANT SELECT ON CDB_TABLESPACES |
| Select | GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS |
The following table lists the grants given to a Privilege (NON-SYS) account.
Privilege (NON-SYS) user grants and privileges
Type of grant | Grant |
|---|---|
Create | GRANT CREATE USER TO ORADBA |
ALTER | GRANT ALTER USER TO ORADBA |
CREATE | GRANT CREATE SESSION to ORADBA with admin option |
CREATE | GRANT CREATE TABLE to ORADBA with admin option |
CREATE | GRANT CREATE SEQUENCE to ORADBA with admin option |
CREATE | GRANT CREATE VIEW to ORADBA with admin option |
CREATE | GRANT CREATE SYNONYM to ORADBA with admin option |
CREATE | GRANT CREATE PUBLIC SYNONYM to ORADBA |
DROP | GRANT DROP PUBLIC SYNONYM TO ORADBA |
CREATE | GRANT CREATE PUBLIC SYNONYM to ORADBA with admin option |
CREATE | GRANT CREATE PROCEDURE to ORADBA with admin option |
SELECT | GRANT SELECT ANY DICTIONARY to ORADBA with admin option |
Comments
Log in or register to comment.