Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need to generate a report showing all users and what objects they have access to???

Re: Need to generate a report showing all users and what objects they have access to???

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Fri, 20 Feb 2004 05:47:37 GMT
Message-ID: <ZbhZb.26889$n17.13750@clgrps13>


Sybrand Bakker wrote:
> On 19 Feb 2004 21:19:00 -0800, ds408_at_yahoo.com (Dave) wrote:
>
>

>>Is there a script handy out there that can do this? Basically, I just
>>need to be able to report on all the users in the DB along with what
>>tables they have access to and the type of access (Select, Update,
>>Delete, Insert, etc.).
>>
>>Any help is greatly appreciated!
>>
>>Thanks,
>>Dave

>
>
>
> If you would have searched Google, instead of posting rightaway and
> waste bandwith, you would have seen Pete Finnigan posted a link to one
> on his own site. And other than that, developing one yourself is an
> useful exercise.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Aw, gee whiz Sybrand ... there you go again, giving away all our secrets. They're not supposed to know about Google until AFTER they graduate. Next thing you know, they'll hear about the online documentation as well. <g>
/Hans Received on Thu Feb 19 2004 - 23:47:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US