Skip to Content
Jan 28, 2021 at 10:38 AM

SAP Oracle OPS$ Users


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$