17.20 - Running the Privilege Check Macro - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

After you create the macro, you can run it to check access privileges for a particular user with the command:

EXECUTE database_name.AllUserRights ('username');
database_name
The name of the macro, and also identifies database for which the macro checks user privileges.
username
The name of a permanent database user for which the macro checks privileges. The user that runs the macro must have EXECUTE privileges on the database that contains the macro.