|
SQL BASIC
|
|
|
|
DATA QUERY LANGUAGE
|
|
|
|
BASIC FUNCTION
|
|
|
|
AGGREGATE FUNCTION
|
|
|
|
DATA MANIPULATION LANGUAGE
|
|
|
|
DATA DEFINITION LANGUAGE
|
|
|
|
DATA CONTROL LANGUAGE
|
|
|
|
OTHERS
|
|
|
|
|
|
|
|
GRANT
|
CREATE <permission>[,<permission-list>
[ON object]
TO <user> [,<user-list>]
[WITH GRANT OPTION];
|
GRANT statement is used to grant users permission to access database objects.
The general syntax of the GRANT permission are shown as above. The [WITH GRANT
OPTION] allows the user to grants the same permission to other users.
|
|