17.00 - Example: Using AllRightsV to Determine User Access Rights - Teradata Database

Teradata Vantage™ - Data Dictionary

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

To determine which users have the privilege to force other users off the system, enter the following:

SELECT DISTINCT UserName FROM DBC.AllRightsV
   WHERE AccessRight = ’AS’ ; 

The ‘AS’ indicates the ABORT SESSION privilege.