Re: users and their privileges

Joe Philip wrote:

> Do anybody have a script to find the users and their privileges of a
> database?

No need for any script.

Just perform the following:

SELECT object_name
FROM all_objects
WHERE object_name LIKE '%PRIV%';

Then do a describe on what you find and all of the information is available with just a SQL statement or two.

Daniel Morgan Received on Mon Jul 29 2002 - 15:31:42 CDT