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
- Start BTEQ or Teradata Studio and log on as the database administrator user.
- Run the following requests:
- For read-only Views
GRANT SELECT ON "Tables_Database" TO "database_name" WITH GRANT OPTION
- For the updatable Views
GRANT SELECT, INSERT, UPDATE, DELETE ON "Tables_Database" TO "database_name" WITH GRANT OPTION
- For read-only Views databases:
|Step||Topic||Resources for Further Information|
|4||Syntax and options for the GRANT (SQL form) statement||SQL Data Control Language|
|Database privileges, including those conferred by object ownership||Security Administration|