GET PERMISSIONS - Teradata Vantage - Database Engine 20

Returns CNS permissions for the specified connection-ID.

Syntax

GET PERMISSIONS username@host

Syntax Elements

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:

Example: Displaying the CNS permissions for a specified user

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

Output:

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