GET PERMISSIONS - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Returns CNS permissions for the specified connection-ID.

Syntax

GET PERMISSIONS username@host
username
logon user name accessing CNS for whom you want to get or view permissions.
host
network host name of the computer to which the user is logged on.

Usage Notes

DBW shows the name of the connection-ID followed by its list of permissions and any granted or revoked utilities.

If the connection-ID does not exist, DBW returns the following message:

user@host: no permissions

Example: Displaying the CNS permissions for a specified user

The following example shows all CNS permissions granted to connection-ID jsmith@isdn1954.

get permissions jsmith@isdn1954

jsmith@isdn1954: set logons log restart grant abort interactive
                 Revoked Utilities: vprocmanager