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 | Information it Contains |
|---|---|
| AllRightsV | The explicit and automatic privileges in effect for each user. |
| AllRoleRights | The explicit privileges in effect for each role. |
| RoleMembersV | The members (users) for each role. |
Teradata Database does not record privileges that derive from ownership, so they are not maintained in DBC.AllRightsV.
For more information about views, see Teradata Vantage™ - Data Dictionary, B035-1092.