User List for Certain Privs

From: Sanjay Mishra <>
Date: Mon, 18 May 2009 09:31:02 -0700 (PDT)
Message-ID: <>

Hi Can somebody shared the SQL who can give the list of user based on PRIVILEGE passed to the script. e. I want to create a list of user who has CREATE SESSION privlege. It should only show me the username or if possible to include Direct/Role  I need to create a report that can list the output as Username        Direct/Role sanjay                Direct santosh              Role Thanks Sanjay
Received on Mon May 18 2009 - 11:31:02 CDT

Original text of this message