find externally authenticated users in a database
954661Aug 22 2012 — edited Aug 22 2012Hi 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.