16.10 - REVOKE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
vkz1472241255652

Purpose

Revokes CNS permissions from a user who is not a member of the tdtrusted user group. Members of tdtrusted implicitly have a non-revocable CNS permissions.

Syntax



username
logon name of the user accessing CNS for whom you want to revoke permissions.
host
network host name of the computer on which that user is logged on.
permission_list
list of supervisor privileges to be revoked, separated by spaces. For a list of the available privileges, see GRANT.

Usage Notes

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

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

Example: Revoking a CNS privilege from a specified user

In this example, the following CNS permissions: START, STOP, and LOGONS, and interactive utilities: System Initializer (SYSINIT) and Filer, are revoked from connection-ID jsmith@isdn1954.

revoke jsmith@isdn1954 start logons interactive (sysinit filer)

CNSSUPV: permissions for jsmith@isdn1954 updated
jsmith@isdn1954: set log restart abort interactive
                 Revoked Utilities: sysinit filer