Working with Table Access Privileges for Views - Teradata Database

Working with Table Access Privileges for Views

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

Note: 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 Teradata Administrator and log on as user DBADMIN.

2 On the main screen, click the Preview Mode button to allow display of generated SQL.

3 Click Tools>Grant/Revoke>Object Rights.

4 In the Grant/Revoke Objects dialog:

a From the Database Name drop-down menu, select the Tables database. This is the object the privileges are granted on.

b From the Object Type drop-down menu, select Database.

c Click the To/From User tab and select a Views database. The privileges are granted to this object.

d In the Normal field, check the following to select the privileges being granted:

For read-only views: Check Select.

For updatable views: Check Select, Insert, Update, and Delete.

e Check the Grant box in the lower right-hand corner of the screen to give the database the privilege of extending the defined privileges to other databases. This specifies the WITH GRANT OPTION clause.

f Click the Grant button. The Query Window displays the generated GRANT statement, for example:

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

g In the Query Window, click the Run Query button . A Query Complete message appears in the bottom left corner of the main window when the query executes.

h Close the Query Window and the Grant/Revoke Objects dialog box.

5 Log off Teradata Administrator.

Reference Information

For Step...	Information on...	Is available in...
4	syntax and options for the GRANT (SQL form) statement	SQL Data Control Language
	database privileges, including those conferred by object ownership	Security Administration