You can query the Data Dictionary to return information about privileges.
| View | Description |
|---|---|
| DBC.UserRightsV[X] | The privileges granted to each user |
| DBC.AllRoleRightsV | The privileges granted to each role |
| DBC.RoleMembersV | Lists each role and its members |
For more information on these views, see Teradata Vantage™ - Data Dictionary, B035-1092.