User List for Certain Privs
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 18 May 2009 09:31:02 -0700 (PDT)
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
Other related posts:
