SAP Oracle OPS$ Users

[former_member725162]

There are some of the users in my oracle database with prefix OPS$ for which Authentication in DBA_USERS is mentioned as PASSWORD and in PASSWORD Column, EXTERNAL is not mentioned.

I am super confused by seeing the settings since OPS$ reflects that user is authenticating at OS and password should show as EXTERNAL. Even couple of accounts like SAPSERVICE<sid> uses OPS$, however not present/active at OS level.

What does this type of setting shows?

FYI - remote_os_authent =FALSE and os_authent_suffix=ops$

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia

SAP Community Moderator

[JamesZ · Accepted solution]

Yes, OPS$ means password is externally only if you don't assign password to the user.
You have no EXTERNAL, then OSP$ OS authentication is not activated for your database user.
For example, we can always create user "OPS$AAA" and login with password.

If remote_os_authent =FALSE, then it is fine for UNIX, it means you didn't turn of OPS$.
But remote_os_authent =FALSE, also works for windows OS.

[dasistdochscheisse]

Since Netweaver 7.3 (or even earlier), OPS$ mechanism shall not be used any longer. Instead use SSFS. You need to adjust how the brtools connect to the database and how the actions in db13 are called. Note 1764043 shows you what to do.

Afterwards, OPS$ users can be deleted.