15.00 - SQL SECURITY Privilege Options - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

SQL SECURITY Privilege Options

The following table defines the meanings of the SQL SECURITY options.

 

Privilege Option

Description

CREATOR

Assign the privileges of the creator of the procedure regardless of its containing database or user.

DEFINER

Assign the privileges of the definer of the procedure.

This is the default.

INVOKER

Assign the privileges possessed by the user at the top of the current execution stack.

OWNER

Assign the privileges owned by the owner of the procedure, which are the privileges possessed by its containing database or user.