Show TOC

Background documentationThe OPS$ Mechanism on Windows

 

For the database, the SAP system is a single user, SAP<SAPSCHEMAID>, or SAPR3whose password is stored in the table SAPUSER. Therefore, to access the database, the SAP system uses a mechanism called the OPS$ mechanism, which works as follows:

  1. When the SAP system accesses the database, it first logs on to the database as user OPS$<operating_system_user>, for example, OPS$<domain>\sapsidadm. (The OPS$ user that corresponds to the operating system user must be defined in the database and identified as externally.)

Note Note

SAP does not support changes of the Oracle parameter os_authent_prefix whose default value is OPS$. The os_authent_prefix is automatically set to O$ if the resulting string (OPS$<os_username> has more than 30 characters).

End of the note.

  1. It retrieves the password for SAP<SAPSCHEMAID> or SAPR3 from the SAPUSER table.

  2. It then logs on to the database as the user SAP<SAPSCHEMAID> or SAPR3.