Grant Privilege statement

Grants or assigns a privilege or list of privileges to a user, user group, or security role. For a list of privilege keywords, see List of privilege tokens.

If you grant a privilege that has prerequisite privileges, those prerequisite privileges are granted as well. For example, if you grant the Configure Group Membership privilege to a user that does not have the Create And Edit Users And Groups privilege, the Create And Edit Users And Groups privilege is automatically granted to that user.

GRANT privilege1[, ...privilegeN]] TO ([USER] 
 "login_name" | 
 [USER] GROUP "user_group_name" | 
 SECURITY ROLE "security_role_name");

where:

• privilege1..N is a privilege from the privilege list.

• USER "login_name" is the login name of the user to be granted the privilege (or set of privileges), of type string.

• USER GROUP "user_group_name" is the name of the user group to be granted the privilege (or set of privileges), of type string.

• SECURITY ROLE "security_role_name" is the name of the security role to which the privilege (or set of privileges) is to be granted, of type string.

Examples

GRANT 
 CREATESCHEMAOBJECTS, CREATEDATAMARTOBJECTS, SCHEDULEREQUEST, USEOBJECTMANAGER, 
 USEVLDBEDITOR TO USER "dsmith";

GRANT 
 WEBDRILLING, WEBEXPORT, WEBOBJECTSEARCH, WEBSORT, WEBUSER, WEBADMIN TO 
 GROUP "Managers";

GRANT 
 USESERVERCACHE, USECUSTOMGROUPEDITOR, USEMETRICEDITOR TO SECURITY ROLE 
 "Architect Users";