Oracle in a Nutshell

Name

GRANT (System Privilege or Role)

Synopsis

GRANT {{privilege | role}[,{privilege | role} ...] 
   | ALL PRIVILEGES}}
TO {username | rolename | PUBLIC}
 [,{username | rolename | PUBLIC} ...]
[WITH ADMIN OPTION]

Grants a system privilege or role to one or more users and/or roles.

Keywords

privilege

Name of a system privilege to be granted. See Chapter 4 for details.

role

Name of a role to be granted. See Chapter 4 for details.

username

Name of a user to be granted a privilege or role.

rolename

Name of a role to be granted a privilege or role.

PUBLIC

Specifies that the granted privilege or role be granted to all users, including those not yet created.

WITH ADMIN OPTION

Specifies that the grantee of the privilege or role can grant the privilege or role to others, and may alter or drop the role.