Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query that will simply return all Oracle role/permissions for all object in a database

Re: query that will simply return all Oracle role/permissions for all object in a database

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Mon, 6 Sep 2004 14:39:40 +0100
Message-ID: <jRN0uDBciGPBRxKT@peterfinnigan.demon.co.uk> 





Hi Derek,



Try my script find_all_privs.sql that is available on my tools page
http://www.petefinnigan.com/tools.htm that recursively lists all
privileges for a user for roles, system privileges and object
privileges.



hth



kind regards



Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.


Received on Mon Sep 06 2004 - 08:39:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US