16.20 - Checking User Privileges - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

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.