Home » RDBMS Server » Security » OS Authentication
OS Authentication [message #54785] Wed, 04 December 2002 17:50 Go to next message
Messages: 38
Registered: May 1999

I am trying to set up OS level authentication for a *regular* user, but am not successful.

Logged in as system/manager to sqlplus:
>create user sdesai identified externally;
>grant CONNECT to sdesai;
>grant dba to sdesai;
>grant release to sdesai;

I have my

I shutdown and STARTUP OPEN.

I tried connecting via sqlplus, but when I entered the username and database, it prompted me for the password.

Is there some parameter that should be specified at db create time?
Are there any other ora files I need to modify?
What should I do?
Newbie. Please help.

Re: OS Authentication [message #54788 is a reply to message #54785] Wed, 04 December 2002 19:26 Go to previous messageGo to next message
Messages: 42
Registered: February 2002
If you created the that user whithn oracle database, you can only connect to oracle with that user, unless you create the same user on the server as well, or are you trying to connect like this


johndoe/johndoe@instancename ?????
Re: OS Authentication [message #54790 is a reply to message #54785] Wed, 04 December 2002 23:55 Go to previous messageGo to next message
Messages: 251
Registered: June 1998
Senior Member
Is "sdesai" your os user? I mean do you have a login in your OS (NT) called sdesai?

If yes then after you have logged into your OS as "sdesai" with NT password you can do as follows
from dos prompt
>sqlplus /
>sqlplus /@yourSID --if you have multiple databases
/ --after you run SQLPLUS utility enter the / in username edit control and click ok, you should be able to login as os user.

In case if you still have error make sure to give the domain name while creating the user
Make sure to include yourdomainnameusername in double quotes.

Re: OS Authentication [message #54793 is a reply to message #54785] Thu, 05 December 2002 01:40 Go to previous messageGo to next message
Messages: 81
Registered: October 2002
to login with OS authentication, you need to start sqlplus as follows:

sqlplus /

the '/' relates to the non-OS authentication where you would login as

sqlplus username/password

Not using the '/ means that oracle will prompt for username and password and will not allow the OS authentication to function for you.

Have fun!
Re: OS Authentication [message #213371 is a reply to message #54785] Wed, 10 January 2007 08:23 Go to previous message
Messages: 10
Registered: June 2006
Junior Member
I think you get the idea. It sounds like you set it up correctly, but you have a usage problem (and potentially a Oracle user vs OS user problem)

If you say Sqlplus myuser@SID, it assumes database authentication and asks you for a password, which means that you can not use OS authentication AND login is a user that is different from the one you are logged into the local system as.
Previous Topic: Can I log in into a user account without knowing his password?
Next Topic: Sys password change
Goto Forum:

Current Time: Fri Jun 09 11:58:30 CDT 2023