Skip to Main Content

Privileges (for all non-standard users and roles)

Run this as sys or system to list all grants for users and/or roles, while filtering out all "standard" grants.
Change the where clause(s) where needed.

Privileges (for a user)

Run this as any user to list all (filtered) grants.
Change the where clause where needed: