Create OS authenticated user account in Oracle !

[Chris Fung]

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

[Yogeeraj_1 · Accepted solution]

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

[Chris Fung]

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

Cheers,

Chris,