12 May 2018 · n-pacha ·       Add to Favorites   Report

Teradata Grant access statements

To Grant access to a user on a database or a table

GRANT ALL PRIVILEGES ON object

TO user

WITH GRANT OPTION;


To only give STORED PROCEDURE access:

GRANT CREATE PROCEDURE, DROP PROCEDURE, EXECUTE PROCEDURE, STATISTICS ON DATABASE_NAME TO USER_ID;


Table / view level grants:

GRANT CREATE TABLE, DROP TABLE ON DATABASE_NAME TO USER_ID;
GRANT CREATE VIEW, DROP VIEW, CREATE MACRO, DROP MACRO ON DATABASE_NAME TO USERNAME:


DML Grants:

GRANT SELECT,DELETE,UPDATE,INSERT,EXECUTE ON DATABASENAME TO USERNAME;

n-pacha

posted on 12 May 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied