a
 
RealNetworks
SQLRef.Com 

            SqlRef.Com


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.  


 
| Freebies | Free Trial | Add to Bookmark | Search | Link to Us |
Copyright © 2006 SqlRef.com. All rights reserved.