17.05 - Checking User Privileges - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

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.