Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Create OS authenticated user account in Oracle !

SOLVED
Go to solution
Chris Fung
Frequent Advisor

Create OS authenticated user account in Oracle !

Hi all,

A quick question - Is is possible to check the data dictionary view to identify which user is identified externally (i.e OS authenticated)and which is database authenticated.

I suspect it should be found in dba_tables (external_name field)...but it shows nothing..

Any idea.

Cheers,

Chris
2 REPLIES
Yogeeraj_1
Honored Contributor
Solution

Re: Create OS authenticated user account in Oracle !

hi chris,

it's dba_users!

if you see 'EXTERNAL' then the user is identified externally!

example:
yd@mydb.mu> create user u1 identified externally;

User created.

Elapsed: 00:00:00.01
yd@mydb.mu> create user u2 identified by password;

User created.

Elapsed: 00:00:00.01
yd@mydb.mu> select username, password from dba_users where username like 'U%';

USERNAME PASSWORD
______________________________ ______________________________
U1 EXTERNAL
U2 4F582751BEFA945A

Elapsed: 00:00:00.03

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Chris Fung
Frequent Advisor

Re: Create OS authenticated user account in Oracle !

Thx....I missed the "password" column ....and that's why !!

Cheers,

Chris,