OPS$ Mechanism is to Logon to Database by O/S Users with Prompting a Passwo

What is OPS$ mechanism?

Question Posted / ramanji chowdary

3 Answers
11602 Views
NTT Data, I also Faced
E-Mail Answers

Answer Posted / ramanji chowdary

OPS$ Mechanism is to Logon to Database by O/S Users with Prompting a Password
• SAP connects to DB using OPS$ user
• OPS$ users can connect to database without passwords
• OPS$ users owns the table SAPUSER
• SAPUSER table contains SCHEMA owner and password (SAPSR3 user)
SAP Work processes connects to DB using OPS$ reads schema user id and password and connects to tables owned by SAPSR3 user.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention what is the difference between central instance & application server?

1052

How many times bdls transaction executes for 2 clients

1828

I need to change the Company address parameters of a user. The path is SU01 -> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

4988

You want to find out which users have an access to a particulat transaction. How would you do that?

1039

How can a user be able to access only for Customizing requests even if assigned se01 and se10?.

3061

How to uncar car/sar files in a single shot?

1227

What do you understand by sap client administration?

1066

What are the different login and password parameters that can be applied in sap system?

1109

What are the different user types in sap system that an admin can use while creating a new user?

1023

What are the Pre- requisite for system copy?

1772

Explain what is luw (logical unit of work)?

987

Explain kernel upgrade?

996

What is JVM switch. Why JVM switch is required ?

2542

What is SSO? How to configure SSO?

1824

how would you troubleshoot the 'user can not print'?

953