Product Documentation

Appearance

ON EXTERNAL object ​

Syntax ​

GRANT { 
   { ALTER EXTERNAL FORMAT | DROP EXTERNAL FORMAT | USAGE EXTERNAL FORMAT }
   [, ...] | ALL [ PRIVILEGES ] }
   ON EXTERNAL FORMAT format_name [, ...]
   TO role_specification [, ...] [ WITH GRANT OPTION ]
GRANT { 
   { ALTER EXTERNAL LOCATION | DROP EXTERNAL LOCATION | USAGE EXTERNAL LOCATION }
   [, ...] | ALL [ PRIVILEGES ] }
   ON EXTERNAL LOCATION location_name [, ...]
   TO role_specification [, ...] [ WITH GRANT OPTION ]
GRANT { 
   { ALTER EXTERNAL STORAGE | DROP EXTERNAL STORAGE | USAGE EXTERNAL STORAGE }
   [, ...] | ALL [ PRIVILEGES ] }
   ON EXTERNAL STORAGE storage_name [, ...]
   TO role_specification [, ...] [ WITH GRANT OPTION ]

Parameters ​

These privileges apply to a single named external format, external location, or external storage object.

ALTER EXTERNAL FORMAT
Privilege to alter a single external format object.
DROP EXTERNAL FORMAT
Privilege to drop a specific external format object.
USAGE EXTERNAL FORMAT
Privilege to use a specific external format object.
ALTER EXTERNAL LOCATION
Privilege to alter a single external location object.
DROP EXTERNAL LOCATION
Privilege to drop a specific external location object.
USAGE EXTERNAL LOCATION
Privilege to use a single external location object.
ALTER EXTERNAL STORAGE
Privilege to alter a single external storage object.
DROP EXTERNAL STORAGE
Privilege to drop a single external storage object.
USAGE EXTERNAL STORAGE
Privilege to use a single external storage object.

Examples ​

GRANT ALTER EXTERNAL LOCATION ON EXTERNAL LOCATION "premdbs3data" TO "ybsql10";
GRANT DROP EXTERNAL LOCATION ON EXTERNAL LOCATION "premdbs3data" TO "ybsql10";
GRANT USAGE EXTERNAL LOCATION ON EXTERNAL LOCATION "premdbs3data" TO "ybsql10";
GRANT ALL ON EXTERNAL STORAGE "premdbs3" TO "ybsql10";

Parent topic:GRANT