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.