17.10 - Granting CNS Permissions - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

To run DBW on any node, you must be a member of the Linux tdtrusted user group or logged in as root. The GRANT command can be used to allow CNS access to non-tdtrusted users. Non-tdtrusted users must have permissions granted to them on the Control Node. Subsequently, they can run DBW from any node.

To grant all permissions to a non-tdtrusted user in DBW, type:

grant xxx @localhost all

where xxx is the user ID.

The permissions should be granted or revoked only when all TPA nodes are running.

Related Information

For information on the three commands that manage CNS permissions, see:
For information on the DBW commands that are always accepted if CNS accepts the connection, see: