Re: what am I entitled to?

Pete Finnigan wrote:

> 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

Nice. Though some of us creative types only activate roles when the end-user logs on with the 'approved' executable. Those that try to bypass the rules ... spend a lot of time looking at dual.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)