Teradata: Grant Select Access on One or Several Columns Only
toc Table of contents
Grant select on one column only
The following code snippet grants SELECT access (code R) on column id only of table TestDb.test_table to 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 category is 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.