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

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

Why use a script when a view will do? Getting it is as easy as 1 .. 2 .. 3

1. Go to http://docs.oracle.com
2. Look in the documentation for the Database Reference Manual
3. Look in the manual.

While you are there, dig out the SQLPlus Users Guide and SQLPlus Reference manual and browse around at the SQLPlus report formatting capabilities.

/Hans Received on Thu Feb 19 2004 - 23:24:30 CST