GRANT - 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

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

Syntax

GRANT username@host permission_list
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