15.00 - GET PERMISSIONS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

GET PERMISSIONS

Purpose  

Returns CNS permissions for the specified connection-ID.

Syntax  

 

Syntax element …

Is the …

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  

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