Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find externally authenticated users in a database

954661Aug 22 2012 — edited Aug 22 2012
Hi all,
can someone please help me out.
I need to write a script to find the list of all the users who are externally authenticated in a database. I found the following query. please let me know if its right and is there any other views to check.

SELECT sid, authentication_type, osuser FROM V$SESSION_CONNECT_INFO where authentication_type='EXTERNAL';


thanks for the help in advance.
This post has been answered by Srini Chavali-Oracle on Aug 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2012
Added on Aug 22 2012
11 comments
2,361 views