15.00 - Granting CNS Permissions - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

Granting CNS Permissions

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 Topics

For information on the three commands that manage CNS permissions, see:

  • “GET PERMISSIONS” on page 178
  • “GRANT” on page 183
  • “REVOKE” on page 189
  • For information on the DBW commands that are always accepted if CNS accepts the connection, see:

  • “Accessing Help on DBW” on page 157
  • “CNSGET” on page 162
  • “GET ACTIVELOGTABLE” on page 169
  • “GET CONFIG” on page 170
  • “GET LOGTABLE” on page 176
  • “GET PERMISSIONS” on page 178
  • “GET RESOURCE” on page 179
  • “GET SUMLOGTABLE” on page 180
  • “GET TIME” on page 181
  • “GET VERSION” on page 182