Teradata: Grant Select Access on One or Several Columns Only

visibility 181 access_time 2 years ago languageEnglish

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. 

copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.41
More from Kontext
Teradata FastLoad Skip Header Line
visibility 1,538
thumb_up 0
access_time 2 years ago
Teradata - Add User to a Role
visibility 160
thumb_up 0
access_time 2 years ago
How to fetch data from Teradata database? forum
visibility 100
thumb_up 1
access_time 8 months ago