Re: finding grants to roles - Urgent

Brian,
 look for static views which contain ROLE or GRANT

 eg

  SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME     LIKE '%ROLE%';  You will get a lot of views you can use.

 Also ... you might consider using the Enterprise   Manager with the Change Management Pack, with which   you can propagate changes from one DB to another   easily.

 Or ... you use a CASE Tool like Oracle Designer to    design and maintain your DB structure. It is able    to generate "reconcile" files which would change your    schema so it matches the one in the Designer.

Regards
Dante

In article <3739FF92.C5B245F4_at_metz.une.edu.au>,   Brian Cameron <bcamero5_at_metz.une.edu.au> 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
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 06:17:06 CDT