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

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