I have a couple of questions here,
1. When we connect to sap giving our SAP User-ID and Pwd, it checks whether this is valid in the Database. But what exactly happens afterwards when we access the DB, does the access to DB happen through my Id or through SAPR3? I guess whenever it tries to access DB, it uses SAPR3. Please Confirm.
If someone can get me the whole process flow I would be really grateful.
2. When we see the log of R3trans -d, we see that it first connects to the DB using OPS$ user to get the SAPR3 password. Once it gets it, all operations are done through SAPR3. My question here is How does it know that OPS$ user has to be used to get SAPR3 password? Is there any settings.
3.I understand SAPREORG directory is used for reorganization. Can someone tell me its exact use.
Waiting for replies.
the answers are (afaik):
1. Yes, the database access (if you run an ABAP application) is executed only as SAPR3 (or SAPR3S or SAPSID or SAP something else). The application handles all the security features inside, which you may know from SAP applications. You may think of it, that SAP uses the database only as a persistent layer. Which is not completely wrong, but the newer your release is, the more database features are used.
2. The behavior you describe is again only used if you chosen Oracle as your database. For all other database, supported by SAP, other connect algorithms are used. OPS$-Users are the Oracle mechanism to authenticate operating systems users without password. The applications then reads the encrypted password of the "connect user" (in your example SAPR3) from the sapuser table. With this username password combination the real connect happen.
3. sapreorg directory keep some protocols and other maintenance files of some tools (today probably from brspace). Again this is only valid for Oracle installations.
The Link will give you completely how exactly SAP handles requests.
All these settings you can find in TPPARAM file located in usr/sap/trans/bin folder.
SAPREORG directory maintains the log of the house keeping jobs which run in SAP. These logs will show status of SAP house keeping jobs. These jobs basically clean up old ABAP dumps, Spool requests etc.
Thanks & Regards