Re: Roles and the data dictionary

Run the following query:

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

That will get you started.

Daniel Morgan

Ryan Gaffuri wrote:

> Which data dictionary view(s) can I use to determine which users have
> which roles? Which data dictionary view can I use to determine what
> rights each role has? Which one(s) can I check to see which role the
> current user has?
>
> Thanks
Received on Thu Apr 04 2002 - 11:03:43 CST