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;
