Re: User Privligies
Date: Fri, 30 Apr 2004 18:52:22 -0700
Message-ID: <1083376341.717854_at_yasure>
Andrzej7 wrote:
> I have about 100 tables in my DB, all start with PS, like
> PSCOUNTY
> PSBRIDGE
> PSDESIGN
>
> And Privlidgies are set up in groups:
>
> ABC_01_ROLE
> ABC_02_ROLE
> ABC_03_ROLE etc.
>
> The ROLEs can have SELECT, UPDATE, DELETE INSERT (granted to the ROLE)
>
> My DBA is gone this week and I need to check the ROLEs for all tables.
>
> How can I request this info from ORACLE so I can look if all tables
> have right privlegies assign to them?
>
> I would like to see something like:
>
> PSCOUNTY ABC_01_ROLE SELECT
> PSBRIDGE ABC_01_ROLE SELECT DELETE INSERT
> PSBRIDGE ABC_02_ROLE SELECT INSERT
> PSBRIDGE ABC_03_ROLE DELETE
> PSDESIGN ABC_01_ROLW SELECT UPDATE DELETE
>
> or
>
> ABC_01_ROLE PSCOUNTY SELECT
> ABC_01_ROLE PSDESIGN UPDATE SELECT
>
> etc.
>
>
> Andy
Look at:
http://www.psoug.org/reference/object_privs.html
There are SQL statements there that can be modified to do what you want though to format them as above would be far more work than it is worth.
Also:
SELECT *
FROM table_privilege_map;
-- 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)Received on Sat May 01 2004 - 03:52:22 CEST