Grant privileges to user in Teradata

While accessing or modifying any table in Teradata we have to have appropriate privileges to do that. For example if you want to SELECT data from a table in Teradata you have to have SELECT privileges. Let's see how we can provide the privileges.

To give privileges you should have administrator rights.

Syntax:-

GRANT SELECT ON TABLE_NAME TO USER-NAME;

Example:-

Let's say your table name is EMPLOYEE and user name is DBUSER.

GRANT SELECT ON EMPLOYEE TO DBUSER;