grant sql

1GRANT privilege_name
2ON object_name
3TO {user_name |PUBLIC |role_name}
4[WITH GRANT OPTION];
5
6privilege_name is the access right or privilege granted to the user. Some of the access rights are ALL, EXECUTE, and SELECT.
7object_name is the name of an database object like TABLE, VIEW, STORED PROC and SEQUENCE.
8user_name is the name of the user to whom an access right is being granted.
9user_name is the name of the user to whom an access right is being granted.
10PUBLIC is used to grant access rights to all users.
11ROLES are a set of privileges grouped together.
12WITH GRANT OPTION - allows a user to grant access rights to other users.

1For example, suppose user JONES needs to use the Change mode 
2of the Table Editor for a table called ORDER_BACKLOG. 
3To grant JONES the UPDATE privilege on the ORDER_BACKLOG table, 
4issue the following statement:
5
6GRANT UPDATE ON ORDER_BACKLOG TO JONES WITH GRANT OPTION