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;

nVector

posted on 12 May 18