| OS group | DB System Privilege | Authorized Operations | Where Referenced |
| oinstall | none | OS privileges to install and upgrade binaries |
inst_group variable in oraInst.loc file; also defined by UNIX_GROUP_NAME variable in response file |
| dba | sysdba |
All
database privileges: start up,shut down, alter database, create and drop database, toggle archivelog mode, back up, and recover database |
DBA_GROUP variable in response file or when prompted by OUI graphical installer |
| oper | sysoper |
Start
up, shut down, alter database, toggle archivelog mode, back up, and recover database |
OPER_GROUP variable in response file or when prompted by OUI graphical installer |
| asmdba | sysdba for asm |
Administrative
privileges to Oracle automatic storage management (ASM) instances |
n/a |
| asmoper | sysoper for asm | Starting up and stopping the Oracle ASM instance | n/a |
| asmadmin | sysasm |
Mounting
and dismounting of disk groups and other storage administration |
n/a |
| backupdba | sysbackup |
New
in 12c; privilege allowing user to start up, shut down, and perform all backup and recovery operations |
BACKUPDBA_GROUP in response file or when prompted by OUI graphical installer |
| dgdba | sysdg |
New
in 12c; associated with privileges related to managing Data Guard environments |
DGDBA_GROUP variable in response
file or when prompted by OUI graphical installer |
| kmdba | syskm |
New
in 12c; associated with privileges related to encryption management |
KMDBA_GROUP variable in response
file or when prompted by OUI graphical installer |
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29843794/viewspace-1291842/ ,如需转载,请注明出处,否则将追究法律责任。