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.