Re: what am I entitled to?

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Tue, 4 May 2004 23:05:49 +0100
Message-ID: <NGsP7LB9OBmARxz4@peterfinnigan.demon.co.uk>

Hi

have a look at a script i wrote called find_all_privs.sql that prints out the system, role and object privileges granted to the user who you pass in. It prints out hierarchically via all the roles. here is an example for the user dbsnmp:

find_all_privs: Release 1.0.6.0.0 - Production on Tue May 04 23:02:15 2004
Copyright (c) 2004 PeteFinnigan.com Limited. All rights reserved.

NAME OF USER TO CHECK                 [ORCL]: dbsnmp
OUTPUT METHOD Screen/File                [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.

For updates please visit http://www.petefinnigan.com/tools.htm

SQL> 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 Tue May 04 2004 - 17:05:49 CDT