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

GRANT

Purpose  

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

Syntax  

 

Syntax element …

Is the …

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.

  • abort: Grants the user authority to issue the ABORT SESSION command.
  • all: Grants the user authority to issue all CNS commands.
  • grant: Grants the user authority to issue the GRANT and REVOKE commands.
  • interactive: Grants the user authority to issue input to interactive programs.
  • Note: Enclose the program or program list, separated by spaces, in parentheses. For example:

    (dbscontrol vprocmanager)

  • logons: Grants the user authority to issue:
  • ENABLE LOGONS/ENABLE ALL LOGONS
  • ENABLE DBC LOGONS
  • DISABLE LOGONS/DISABLE ALL LOGONS
  • log: Grants the user authority to issue the LOG command.
  • restart: Grants the user authority to issue the RESTART command.
  • set: Grants the user authority to issue CNSSET and SET commands.
  • start: Grants the user authority to issue the 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” on page 189.

    Example  

    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