During my search for proper scheme and ID I found out interesting document which is summarizing ID created by Oracle and SAP during initial system installation.
Interesting is, that nearly half of them is not used in my work *grin*.
IDs used by SAP are:
SAPR3 / SAP<sid> / SAP<xyz> / SAPSR3
- owner of all R/3 object
SAPR3SHD / SAP<sid>SHD / SAP<xyz>SHD / SAPSR3SHD
- not required in BAU (only for SAP shadow upgrade)
SYSTEM
- used and is pretty powerful (and owner of some objects)
SYS
- powerful owner of most system tablespaces
OPS$<sid>ADM (NT, UNIX) / OPS$SAPSERVICE<sid> (NT)
- for BRTOOLS and used by R/3 itself
OUTLN
- Stored Outlines are managed in the OUTLN user.
SAP<sid>DB / SAP<xyz>DB / SAPSR3DB
- for J2EE environment as of Release 6.30
SAPPCD
- for EP environment.
SAPWCM
- for EP environment.
TSMSYS
- no use in R/3 environment.
DBSNMP
- no use in R/3 environment.
DIP
- no use in R/3 environment.
CTXSYS
- no use in R/3 environment (except for Requisite/BugsEye)
INTERNAL
- no more available (from 9.0).
There is link to original and very interesting document:
http://kmit4u.blogspot.cz/2010/09/sap-basis-sap-env-for-oracle-schemapriv.html
No comments:
Post a Comment