| How to authenticate a user by OS [message #411049] |
Wed, 01 July 2009 12:52  |
surenhr
Messages: 45
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 #411720 is a reply to message #411081] |
Mon, 06 July 2009 07:48  |
surenhr
Messages: 45
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 #411893 is a reply to message #411049] |
Tue, 07 July 2009 04:47 |
surenhr
Messages: 45
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 #411919 is a reply to message #411049] |
Tue, 07 July 2009 05:23 |
surenhr
Messages: 45
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: 45
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: 45
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
