17.10 - GRANT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Grants CNS permissions to a user who is not a member of the tdtrusted user group.

Syntax

GRANT username@host permission_list

Syntax Elements

username
logon name of the user accessing CNS for whom you want to grant permissions.
host
network host name of the computer to which you are logged on.
permission_list
list of supervisor privileges to be granted, separated by spaces. The following table lists the permissions.
Permission Grants User Authority to Issue
abort ABORT SESSION command
all All CNS commands
grant GRANT and REVOKE commands
interactive Input to interactive programs

Separate listed programs by a space and enclose the list in parentheses. For example:

(dbscontrol vprocmanager)
logons
  • ENABLE LOGONS/ENABLE ALL LOGONS
  • ENABLE DBC LOGONS
  • DISABLE LOGONS/DISABLE ALL LOGONS
log LOG command
restart RESTART command
set CNSSET and SET commands
start START and STOP commands

Usage Notes

The GRANT command only affects future DBW sessions. You must stop and restart the DBW session for the updated permissions to take effect.

If interactive permission has been granted, it is added to the GRANT list. If interactive permission has been revoked, then it is removed from the GRANT list if it exists there. To revoke interactive permissions, see REVOKE.

Example: Granting CNS permissions

In this example, connection-ID jsmith@isdn1954 is granted interactive privileges to the Vproc Manager utility.

grant jsmith@isdn1954 interactive(vprocmanager)

CNSSUPV: permissions for jsmith@isdn1954 updated
jsmith@isdn1954: set logons log restart grant abort interactive
                 Granted Utilities: vprocmanager