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

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
OS_AUTHENT_PREFIX=""
REMOTE_OS_AUTHENT=true

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.

-Siddharth
Re: OS Authentication [message #54788 is a reply to message #54785] Wed, 04 December 2002 19:26 Go to previous messageGo to next message
Helena
Messages: 42
Registered: February 2002
Member
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

sqlplus

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
Ravi
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 /
(or)
>sqlplus /@yourSID --if you have multiple databases
(or)
/ --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
ex:
CREATE USER "YOURDOMAINNAMEUSERNAME" IDENTIFIED EXTERNALLY;
Make sure to include yourdomainnameusername in double quotes.

Regards,
Ravi
Re: OS Authentication [message #54793 is a reply to message #54785] Thu, 05 December 2002 01:40 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
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
macquivr
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: Thu Dec 08 10:46:21 CST 2016

Total time taken to generate the page: 0.05014 seconds