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

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
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: