Grant Access to Teradata Tables and Views

GRANT is a native SQL command that authorizes users to access Teradata tables. As a run-time requirement, this command must be issued after the adapter is installed. It is also required for the AUTODBC facility in order to allow access to the Data Dictionary and Directory system tables.

You need to know the command syntax and have authorization for the tables or views and plans or modules in question. If you are unfamiliar with the GRANT command, contact your Teradata database administrator for assistance.

To distribute SELECT privileges, issue the following command.

GRANT SELECT ON object_name TO {tuserid|PUBLIC} ;

where:

object_name

Is the name of the Teradata table or view.

tuserid

Is an authorized user ID for an individual user.

PUBLIC

Allows all users to access the specified table or view.

Note: Additional privileges may be required to use two adapter features, FOCUS CREATE FILE and ON TABLE HOLD FORMAT SQLDBC, which dynamically create Teradata tables with indices.


Information Builders