Tuesday, 9 March 2021

The OSDBA subset job role separation privileges and groups consist of the following:

 The OSDBA subset job role separation privileges and groups consist of the following:


The OSBACKUPDBA group for Oracle Database (ORA_HOMENAME_SYSBACKUP)


Use this group if you want a separate group of operating system users to have a limited set of database backup and recovery related administrative privileges (the SYSBACKUP privilege).


The OSDGDBA group for Oracle Data Guard (ORA_HOMENAME_SYSDG)


Use this group if you want a separate group of operating system users to have a limited set of privileges to administer and monitor Oracle Data Guard (the SYSDG privilege).


The OSKMDBA group for encryption key management (ORA_HOMENAME_SYSKM)


Use this group if you want a separate group of operating system users to have a limited set of privileges for encryption key management such as Oracle Wallet Manager management (the SYSKM privilege).


The OSRACDBA group for Oracle Real Application Clusters Administration (ORA_HOMENAME_SYSRAC)


Use this group if you want a separate group of operating system users to have a limited set of Oracle Real Application Clusters (RAC) administrative privileges (the SYSRAC privilege). To use this privilege:


Add the Oracle Database installation owners as members of this group.

No comments:

Post a Comment