Re: finding privileges granted to roles - Urgent!

Brian Cameron wrote:

> Hi,
>
> We are having a permissions problem. There are two database instances on
>
> separate machines, which are the supposed to be the same structure.
>
> One instance works and one doesn't
>
> To find out what is wrong I need to identify and compare two databases
> in
> each database
>
> I need to identify what objects these roles have been granted priviliges
> on
> (select, insert, update,delete) and then compare them.
>
> I propose a sql statement spooled to a file which would list each role
> and
> each object that it has privileges on.
>
> The at the unix level diff the files.
>
> Can any one help me with the correct SQL statement to gather the info I
> need?
>
> Oracle is 7344
> OS is Digital unix V4.0e
>
> TIA
>
> Brian
> bcamero5_at_metz.une.edu.au

--
Hi

You have to select from DBA_TAB_PRIVS and DBA_SYS_PRIVS to get the granted privileges of the database. Maybe You have also to select from DBA_COL_PRIVS. Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.