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.