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
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.
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?