Oracle SQL: the Essential Reference

GRANT (System Privilege or Role)

GRANT {privilege | role}[,{privilege | role} ...] 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

Specifies the name of a system privilege to be granted.

role

Specifies the name of a role to be granted.

username

Specifies the name of a user to be granted a privilege or role.

rolename

Specifies the 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.

Examples

Grant the account_admin role to scott and debby:

GRANT account_admin TO scott, debby;

Grant the CREATE USER and DROP USER privileges to the dba_assist role:

GRANT create user, drop user TO dba_assist;