Teradata: Grant Select Access on One or Several Columns Only

Raymond Tang Raymond Tang 1050 1/19/2021

Grant select on one column only

The following code snippet grants SELECT access (code R) on column idonly of table TestDb.test_tableto a role named TestRole.

grant select (id) on TestDb.test_table to TestRole;

Grant select on multiple columns

To grant SELECT access on multiple columns only, use similar SQL as the following code snippet:

grant select (id,category) on TestDb.test_table to TestRole;

Compared with the first query, access on an additional column named categoryis also granted.

Grant select on all columns

grant select on TestDb.test_table to TestRole;

When column names are not specified, permission is granted on all columns.

The above statements apply to both tables and views.

teradata