REVOKE - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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