Teradata has a special category of keywords that you can use to grant multiple privileges. For example, the following GRANT request grants both the CREATE DATABASE and DROP DATABASE privileges to user_name using the keyword DATABASE:
GRANT DATABASE on user_name;
The following table lists this class of keywords and indicates the multiple privileges that they confer when they are granted on a user or database:
Keyword | Privileges Conferred |
---|---|
ALL | all implicit and explicit object privileges owned by the grantor WITH GRANT OPTION that pertain to the type of object specified, and only those privileges, are granted on the specified database object. |
AUTHORIZATION |
|
CHECKPOINT |
|
DATABASE |
|
DROP |
|
EXECUTE |
|
FUNCTION |
|
GLOP |
|
INDEX |
|
MACRO |
|
MAP |
|
PROCEDURE |
|
PROFILE |
|
RESTORE | ability to execute the following HUT commands on the specified object:
|
ROLE |
|
SHOW | the ability to execute the following SQL statements only:
|
STATISTICS |
|
TABLE |
|
TRIGGER |
|
USER |
|
VIEW |
|