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

GRANT <privilege_type>
ON       <databasename>.<tablename>
TO      <user_name>;

Examples of Granting privileges

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

GRANT SELECT
ON       Banking_DB.Customer_Txn
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

GRANT SELECT, UPDATE, INSERT, DELETE
ON       Banking_DB.Customer_Txn
TO       Bank_Admin;

Recommended Articles

• Insert Into Statement in Teradata
• INSERT INTO SELECT Statement in Teradata with examples