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, 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";