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

Thread: OPS$ accounts

  1. #1
    Join Date
    Dec 2002
    Posts
    4

    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?

    Thanks.

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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"
    Agasimani
    OCP(10g/9i/8i/8)

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