OPS$ accounts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: OPS$ accounts

  1. #1
    Join Date
    Dec 2002

    OPS$ accounts

    We have users utilizing a VB front end to log into the database. When they are logged in, SYS.AUD$ shows their username as OPS$/. However, when viewing DBA_USERS there are no usernames listed as OPS$.

    I realize OPS$ is used for OS authentication, but I always thought that a user had to be created in the database as OPS$?

    Anyone know why the username is being listed in SYS.AUD$ in this manner?


  2. #2
    Join Date
    Feb 2001
    Execute the following statement:
    select name, value from v$parameter where name = 'os_authent_prefix';

    This is the value which is prefixed with the os username for the oracle authentication. For example if value = "OP$" and the os username is "ABC", then the oracle authenticates it as "OP$ABC"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width