December 2002
Intermediate to advanced
928 pages
85h 29m
English
GRANT (System Privilege or Role)
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.
Name of a system privilege to be granted. See Chapter 4 for details.
Name of a role to be granted. See Chapter 4 for details.
Name of a user to be granted a privilege or role.
Name of a role to be granted a privilege or role.
Specifies that the granted privilege or role be granted to all users, including those not yet created.
Specifies that the grantee of the privilege or role can grant the privilege or role to others, and may alter or drop the role.