Automatic Privileges for Created Users and Databases - Teradata Database

Automatic Privileges for Created Users and Databases

When you create a user or database, it automatically gets the following privileges on itself:

ANY

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

SELECT

STATISTICS

RESTORE

UPDATE

Note: These same privileges are automatically given to creators, with the exception of CREATE USER, CREATE DATABASE, DROP USER, and DROP DATABASE.

Reference Information

For Step...	Information on...	Is available in...
5	syntax and options for the GRANT (SQL form) statement	SQL Data Control Language
	database privileges, including those conferred by object ownership	Security Administration