GRANT statement 

The GRANT statement assigns privileges for tables, individual columns and roles, and the execution privilege for a database procedure.

Syntax

<grant statement> ::= GRANT <priv spec>,... TO <grantee>,... [WITH GRANT OPTION]
| GRANT EXECUTE ON <dbproc name> TO <grantee>,...

priv spec, grantee, dbproc name

Explanation

The privileges in the privilege specification are assigned to the users, user groups, and roles specified in the grantee list.

WITH GRANT OPTION

Users or usergroups identified as grantees are allowed to pass on their privileges to other users. The current user must have the authorization to pass on these privileges.

The WITH GRANT OPTION cannot be specified if grantee identifies a role.

GRANT EXECUTE

GRANT EXECUTE allows the user identified by grantee to execute the specified database procedure. The current user must be the owner of the database procedure.