Feb 12
11
Following are the OS Users and Groups will be created while installation of SAP systems on Oracle RDBMS, which will be used to connect, access and administer oracle instances with the special system privilege of SYSDBA and SYSOPER. Object privileges control operations on object level, such as querying data in tables or views (SELECT) or modifying data (INSERT, UPDATE, DELETE).
Users and Groups of UNIX Environment
| OS User | OS Groups relevant to Oracle | Oracle Privileges |
|---|---|---|
| ora<dbsid> | dba | Full administration of all instances |
| oper | Restricted administration of all instances | |
| <sapsid>adm | dba | Full administration of all instances |
| oper | Restricted administration of all instances |
Users and Groups of Windows Environment 2000/2003/2008
| OS User | OS Groups relevant to Oracle | Oracle Privileges |
|---|---|---|
| <sapsid>adm | ORA_<DBSID>_ORA | Full administration of instance <DBSID> |
| ORA_<DBSID>_OPER | Restricted administration of all instance <DBSID> | |
| ORA_DBA | Full administration of all instances | |
| SAPService<SAPSID> | ORA_<DBSID>_ORA | Full administration of instance <DBSID> |
| ORA_<DBSID>_OPER | Restricted administration of all instance <DBSID> | |
| ORA_DBA | Full administration of all instances |
