Grant Select access to table in Teradata

Grant in Teradata

Grant statement is used to provide the privileges (permissions) such as SELECT,INSERT,UPDATE on a table to user. For example, If you created the table in your database, other users will not be able to access this table. In that case, you need to provide the access on the table to other users.

Also we can use Grant statement to provide the access to other database objects such as database,functions, triggers and so on.

Grant statement Syntax

Examples of Granting privileges

Lets provide the SELECT access on Customer transaction table to Bank_Admin.

Similarly we can mention other permission type(INSERT/UPDATE/DELETE) also in the same Grant statement. The following statement allows user Bank_admin to perform selects, updates, inserts and deletes on Customer_Txn table in the Banking_db

Recommended Articles