15.00 - Granting CNS Permissions - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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.

WARNING:

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