OPERATING SYSTEM GROUPS USED IN ORACLE SOFTWARE:

OPERATING SYSTEM GROUPS USED IN ORACLE SOFTWARE:

ORACLE GRID INFRASTRUCTURE:

- OSASM Group for Oracle ASM Administration.
- OSDBA Group for ASM Database Administrator group for Oracle ASM
- OSOPER Group for Oracle ASM group for Oracle ASM operators (Optional)

Oracle Database Software Group:

- OSDBA GROUP   ==> Full DBA privileges
- OSOPER GROUP - 
- OSBACKUPDBA
- OSKMDBA GROUP
-OSRACDBA GROUP (New in 12.2, grid user must be part of it if it exist.)

Oracle Grid Infrastructure Groups:

Group	Typical Name	Purpose
Install	Oinstall	User have Oracle installation owner system privileges, also known as the orainventory group.
OSASM	DBA OR ASMADMIN	Users are granted the SYSASM privilege access to Oracle ASM instance for administrative function such as instance startup and shutdown along with mounting and dismounting of diskgroup.
OSDBA	DBA OR ASMDBA	Users are granted read and write access to files managed by Oracle ASM. All Oracle database software owners must be a member of this group.
OSOPER	DBA OR ASMOPER	Users are granted the SYSOPER privilege access to Oracle ASM instances providing a limited subset of administrator functions such as starting and stopping Oracle ASM instances.

Oracle Database Group:

INSTALL	OINSTALL	User have Oracle installation owner system privileges, also known as the orainventory group.
OSDBA	DBA	Users are granted the SYSDBA Database Administrator privilege allowing access to all user data, startup/shutdown, create/drop database, backup/recovery and open/mount functions.
OSOPER	DBA OR OPER	Users are granted the SYSOPER privilege providing a limited subset of administrator functions without access to user data. It allows startup/shutdown,open/mount, backup, and only complete recovery operations as compared to partial or limited recovery.