SQL Guide
:
Using SQL for database administration
:
Managing user privileges and roles
: Granting privileges to a user by giving the user a role
Granting privileges to a user by giving the user a role
GRANT
role_name
TO
username
;
The following example gives the user CALVIN the privileges that are defined for the GUEST_USERS role.
GRANT GUEST_USERS TO CALVIN;
See also
Managing user privileges and roles
This site works best with JavaScript enabled