[Objects and System Grants]The definitive query

Hi,

I'm looking for a query or unions of queries that would list all grants

The header of the query would look like this

User_or_Role has_this_grant on_this_object granted_by....

It's just because a consultant DBA has granted select on all tables and that's a System grant, it's quite tricky to remove it from 200+ users who might have lesser select grants.

Many thanks

JayBee Received on Tue Jun 20 2006 - 02:59:43 CDT