GRANT {
{ ALL [ PRIVILEGES ] |
[ ALL BUT ] privilege [,...] |
CTCONTROL
} ON object |
map_privilege [,...] |
role_privilege [,...] |
compute_group_privilege [,...] |
compute_profile_privilege [,...] |
compute_access_privilege [,...] |
profile_privilege [,...] |
zone_privilege [,...] |
CONSTRAINT ASSIGNMENT |
CONSTRAINT DEFINITION
}
TO {
{ grantee [,...] | PUBLIC } [ WITH GRANT OPTION ] |
role_name [,...]
} [;]
- object
{ { database_name | user_name } [ .object_name ] |
object_name |
[ PROCEDURE ] [ database_name. | user_name. ] procedure_name |
SPECIFIC FUNCTION [ database_name. | user_name. ]
specific_function_name |
[ FUNCTION ] [ database_name. | user_name. ]
function_name ( [ function_parameter [,...] ] ) |
TYPE [SYSUDTLIB.] UDT_name
}
- function_parameter
[ parameter_name ] data_type
- data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE |
{ TIME | TIMESTAMP } [ (fractional_seconds_precision) ] [WITH TIME ZONE] |
INTERVAL YEAR [(precision)] [TO MONTH] |
INTERVAL MONTH [(precision)] |
INTERVAL DAY [(precision)]
[TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL HOUR [(precision)]
[TO { MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] |
INTERVAL SECOND [ (precision [, fractional_seconds_precision ] ) |
PERIOD (DATE) |
PERIOD ( { TIME | TIMESTAMP } [(precision)] [WITH TIME ZONE] ) |
REAL |
DOUBLE PRECISION |
FLOAT [ (integer) ] |
NUMBER [ ( { integer | * } [, integer]... ) ] |
{ DECIMAL | NUMERIC } [ ( integer [, integer]... ) ] |
{ CHAR | BYTE | GRAPHIC } [ (integer) ] |
{ VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } [ (integer) ] |
LONG VARCHAR |
LONG VARGRAPHIC |
{ BINARY LARGE OBJECT | BLOB | CHARACTER LARGE OBJECT | CLOB }
( integer [ G | K | M ] ) |
[SYSUDTLIB.] { XML | XMLTYPE } [ ( integer [ G | K | M ] ) ]
[ INLINE LENGTH integer ] |
[SYSUDTLIB.] JSON [ ( integer [ K | M ] ) ] [ INLINE LENGTH integer ]
[ CHARACTER SET { UNICODE | LATIN } | STORAGE FORMAT { BSON | UBJSON } ] |
[SYSUDTLIB.] ST_GEOMETRY [ (integer [ K | M ]) ] [ INLINE LENGTH integer ] |
[SYSUDTLIB.] DATASET [ (integer [ K | M ]) ]
[ INLINE LENGTH integer ] [storage_format] |
[SYSUDTLIB.] { UDT_name | MBR | ARRAY_name | VARRAY_name }
}