User List for Certain Privs
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 18 May 2009 09:31:02 -0700 (PDT)
Message-ID: <153932.49817.qm_at_web51310.mail.re2.yahoo.com>
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
Date: Mon, 18 May 2009 09:31:02 -0700 (PDT)
Message-ID: <153932.49817.qm_at_web51310.mail.re2.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 18 2009 - 11:31:02 CDT