| How to authenticate a user by OS [message #411049] |
Wed, 01 July 2009 12:52  |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Dear All ,
I want to know , how to create an oracle user which is authenticated externally by an operating system ..
create user <username> identified externally
But i want to know how i can test that whether user is able to be identified externally because when i login with this user in sql/plus, it still asks for a password .
Kindly help .
|
|
|
| Re: How to authenticate a user by OS [message #411051 is a reply to message #411049] |
Wed, 01 July 2009 13:24  |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
How do you connect?
Use SQL*Plus and copy and paste your session.
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
Regards
Michel
|
|
|
|
|
| Re: How to authenticate a user by OS [message #411720 is a reply to message #411081] |
Mon, 06 July 2009 07:48 |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Hi,
I had gone through the guide
and did the following steps.
1.There was an OS user in the ORA_DBA
group named 'oraadmin'
2.I have created an oracle user using
Create user "OPS$DOMAIN.NAME/ORAADMIN" identifed externally
3.Grant create session to "OPS$DOMAIN.NAME/ORAADMIN"
4. sqlplus /nolog
5. conn /
It got connected and worked fine .
But the problem i am facing is when i created a new OS user
and assugned this user the ORA_DBA group.
Whenever i run the query
select sys_context('userenv','os_user') from dual;
It always shows the DOMAIN.NAME/ORAADMIN but now
my user is something else.
How to go about it ?
|
|
|
|
|
|
| Re: How to authenticate a user by OS [message #411875 is a reply to message #411868] |
Tue, 07 July 2009 04:08 |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Because you are in the ORA%DBA OS group and you fit the external name convention (OPS$ by default).
It is explained in the link I posted you, so please read it.
Regards
Michel
[Updated on: Tue, 07 July 2009 04:09]
|
|
|
| Re: How to authenticate a user by OS [message #411893 is a reply to message #411049] |
Tue, 07 July 2009 04:47 |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Dear Michel,
Thanks for the solution.
I did go through the link you have posted.
Beacuse of that only i was able to configure external
authentication.
I had one more question sir, when i create a new OS user and
put it in ORA_DBA group and run the following command
create user "OPS$TCS091000\OSUSERTEST" identified externally;
SQL> conn /
ERROR:
ORA-01017: invalid username/password; logon denied
Why its not allowing to log in to oracle
|
|
|
| Re: How to authenticate a user by OS [message #411900 is a reply to message #411893] |
Tue, 07 July 2009 04:58 |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Something wring in your environment. As I don't have it I can't say what.
All is explained in the documentation, if you follow it everything runs fine.
Also have a look to Windows specific doc.
Regards
Michel
|
|
|
|
| Re: How to authenticate a user by OS [message #411919 is a reply to message #411049] |
Tue, 07 July 2009 05:23 |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Hi ,
Can we switch between various authentication mechanisms using
Alter user command ?
- Is there any Parameter with which we can identify that
the particular user is identified by password or external?
Regards
Suren
|
|
|
|
| Re: How to authenticate a user by OS [message #411957 is a reply to message #411049] |
Tue, 07 July 2009 06:10 |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Dear Michel,
The password is set for the user who is identified externally as well.
How password can be used to distinguish ?
SQL> create user external identified by externally;
User created.
SQL> select password from dba_users where username='EXTERNAL';
PASSWORD
------------------------------
F9F3AAA4601751D8
and more thing, if we have more then 1 externally authenticated
users, then how to connect as we use only conn / which
connects to any externally authenticated user .
Thanks
Suren
|
|
|
|
| Re: How to authenticate a user by OS [message #411985 is a reply to message #411049] |
Tue, 07 July 2009 06:46 |
surenhr
Messages: 38
Registered: August 2007
Location: gurgoan |
Member |
|
|
Thanks,
I got the issue with the command.
But what about
if we have more then 1 externally authenticated
users, then how to connect as we use only conn / which
connects to any externally authenticated user . How to connect
to a particular externally authenticated user
Thanks,
Suren
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
