Working with Table Access Privileges for Views - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

You must grant table access privileges to all views databases to allow the views within each database to access tables in the Tables database.

When table access privileges are granted to a Views database, the individual views inherit the right to access tables in the Tables database from the parent Views database.

Granting Table Access to Each Views Database

  1. Start BTEQ or Teradata Studio and log on as the database administrator user.
  2. Run the following requests:
    • For read-only Views databases:
      GRANT SELECT ON "Tables_Database" TO "database_name" WITH GRANT OPTION
    • For the updatable Views databases:
      GRANT SELECT, INSERT, UPDATE, DELETE ON "Tables_Database" TO "database_name" WITH GRANT OPTION

Related Information

Reference topics are arranged according to the first step in which the topic appears.

Step Topic Resources for Further Information
2 Syntax and options for the GRANT (SQL form) statement Teradata Vantage™ - SQL Data Control Language, B035-1149
Database privileges, including those conferred by object ownership Teradata Vantage™ - Analytics Database Security Administration, B035-1100