Before you explicitly grant any privilege to a user or role, you can access Data Dictionary views to determine which privileges are already in effect.
| View | Contents |
|---|---|
| AllRightsV | Explicit and automatic privileges in effect for each user. |
| AllRoleRights | Explicit privileges in effect for each role. |
| RoleMembersV | Members (users) for each role. |
Vantage does not record privileges that derive from ownership, so those privileges are not maintained in DBC.AllRightsV.
See Using System Views.