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
|
1 2 3 |
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.
|
1 2 3 |
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
|
1 2 3 |
GRANT SELECT, UPDATE, INSERT, DELETE ON Banking_DB.Customer_Txn TO Bank_Admin; |
Recommended Articles
