Newly created users are automatically granted the privileges needed to create and maintain objects in their space, but must be explicitly granted the privileges needed to CREATE USER/MODIFY USER or CREATE DATABASE (see also “GRANT (SQL Form)” in Teradata Vantage™ - SQL Data Control Language, B035-1149).
Newly created users do not receive WITH GRANT OPTION privileges for any of the automatically granted privileges.
The following privileges are automatically granted to a user when it is created.
- CHECKPOINT
- CREATE AUTHORIZATION
- CREATE MACRO
- CREATE TABLE
- CREATE TRIGGER
- CREATE VIEW
- DELETE
- DROP AUTHORIZATION
- DROP FUNCTION
- DROP MACRO
- DROP PROCEDURE
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- DUMP
- EXECUTE
- INSERT
- RESTORE
- SELECT