17.10 - REVOKE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
vkz1472241255652

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

REVOKE username@host permission_list

Syntax Elements

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: DBS Control and Vproc Manager, are revoked from connection-ID jsmith@isdn1954.

revoke jsmith@isdn1954 start logons interactive (dbscontrol vprocmanager)

CNSSUPV: permissions for jsmith@isdn1954 updated
jsmith@isdn1954: set log restart abort interactive
                 Revoked Utilities: dbscontrol vprocmanager