Hi,

Might be a bit late but have a look at a script i wrote called
find_all_privs.sql that lists the privileges a user has heirarchically
via roles. here is an example for the user DBSNMP:

find_all_privs: Release 1.0.6.0.0 - Production on Fri Jul 30 15:22:38
2004
Copyright (c) 2004 PeteFinnigan.com Limited. All rights reserved.

NAME OF USER TO CHECK [ORCL]: DBSNMP
OUTPUT METHOD Screen/File [S]: S
FILE NAME FOR OUTPUT [priv.lst]:
OUTPUT DIRECTORY [DIRECTORY or file (/tmp)]:

User => DBSNMP has been granted the following privileges
====================================================================
ROLE => CONNECT which contains =>
SYS PRIV => ALTER SESSION grantable => NO
SYS PRIV => CREATE CLUSTER grantable => NO
SYS PRIV => CREATE DATABASE LINK grantable => NO
SYS PRIV => CREATE SEQUENCE grantable => NO
SYS PRIV => CREATE SESSION grantable => NO
SYS PRIV => CREATE SYNONYM grantable => NO
SYS PRIV => CREATE TABLE grantable => NO
SYS PRIV => CREATE VIEW grantable => NO
SYS PRIV => SELECT ANY DICTIONARY grantable => NO
TABLE PRIV => EXECUTE object => SYS.UTL_FILE grantable => NO
TABLE PRIV => SELECT object => SCOTT.BONUS grantable => NO

PL/SQL procedure successfully completed.

You can get it at http;//www.petefinnigan.com/tools.htm

hth

kind regards

Pete

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


Oracle LazyDBA home page