DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    I am clear with theoretically what OS authentication will do.
    But can anyone explain ,giving an example.
    How to create OS login name?,
    Where should I create?
    In which Domain I need to include the user?.
    Is there any previlage to be given etc etc

    Ohhh.I am so much confused
    please help me

  2. #2
    Join Date
    Jul 2000
    You can create a OS login name just like you create a normal user in OS.You should create a oracle user with the same name prefixed by some string ,say,OPS$ .e.g. If you create a OS user called "Vani",you should create a oracle user called "OPS$vani" and also mention that the user is identified externally during user creation in oracle. You should set the parameter OS_AUTHENT_PREFIX in init.or to OPS$.Next time you login as vani,oracle concatenates the value mentioned in OS_AUTHENT_PREFIX with your login and validates it in the database.

    Hope this clarifies your doubt.


  3. #3
    Join Date
    Mar 2002
    I am going to try this.
    Before that , think that I created OS user and also created a user with same name(prefixed by whatever in OS_AUTHENT_PREFIX Parameter) in the database.
    Now I log on to some other machine ( not in the machine where I created my database) with OS user name say Vani.(say with the one I created)
    No I would like to start a session.I have Sql *plus installed in the machine I am going to use. Normally a dialogue box appears to get input like username,password and oracleSid.
    So,Now I should not get that brecause OS authentication given to that user ,instead I shold be able to get SQL prompt.
    Is it true?

    [Edited by Vani on 03-21-2002 at 06:01 PM]

  4. #4
    Join Date
    Nov 2000
    Hi Vani,

    In the logon screen, enter / in username and enter the connect string. This should work.



  5. #5
    Join Date
    Mar 2002
    I did followed the same thing.
    I first tried on the same machine where I created Database.It didn't wirk.I set remote_login_password-none also in parameter file.
    Could any one help me?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.