Re: Oracle Roles/Privileges Report

From: Rookie DBA <junk_at_junk.com>
Date: Thu, 21 Nov 2002 00:49:51 GMT
Message-ID: <P4WC9.88172$NH2.5528@sccrnsc01>

http://asktom.oracle.com/pls/ask/f?p=4950:8:1621702::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:853427230099,%7Brole%7D%20and%20%7Bhierarchy%7D

May be this will help you ....

"Trent" <trent_vinyl_at_hotmail.com> wrote in message news:5d41cd33.0211201535.727d6643_at_posting.google.com...
> I'm currently working in a messy environment. They have ~250 users
> and ~300 roles defined. There is no documentation whatsoever. I'd
> like to know if there is a tool out there that will diagram
> hierarchically the role relationships (or if someone can supply me
> with a script). I'm not really too sure how to do this manually
> outside of doing it step by step (i.e. find a base role (one that
> isn't granted to other roles) and continue working up).
>
> Once I have this done, I then have to look at the object priv's on
> each role and look for duplication.
>
> Any help would be appreciated.
Received on Wed Nov 20 2002 - 18:49:51 CST