Teradata Vantage provides a special category of keywords that you can use to grant multiple privileges. For example, the following request uses the keyword DATABASE to grant both the CREATE DATABASE and DROP DATABASE privileges on user_name1 to user_name2:
GRANT DATABASE ON user_name1 TO user_name2;
The following keyword grants enter multiple privileges for the grantee in the DBC.AccessRights table:
| Keyword | Included Privileges |
|---|---|
| ALL | All implicit and explicit object privileges that the grantor owns, and on which the grantor has WITH GRANT OPTION, on the object specified in the ON clause. |
| CHECKPOINT | The privilege to run the:
|
| DATABASE |
|
| FUNCTION |
|
| GLOP |
|
| INDEX |
|
| MACRO |
|
| MAP |
|
| OVERRIDE |
|
| PROCEDURE |
|
| PROFILE |
|
| RESTORE | The privilege to run the following HUT commands:
|
| ROLE |
|
| SHOW | Only the following variations of the HELP and SHOW commands:
|
| TABLE |
|
| TRIGGER |
|
| USER |
If the target of a GRANT USER is a user, then USER confers CREATE and DROP
privileges. If the target of a GRANT USER is a database, then
USER confers the privilege to CREATE users within the
database.
|
| VIEW |
|
| ZONE |
|