17.10 - Dropping a Role - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

If you drop a role while a member user is logged on, the user immediately loses the privileges granted to that role.

The user must use the SET ROLE statement to reactivate some or all of the remaining roles within a session.