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
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572

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.