GRANT PRIVILEGE

Syntax

GRANT PRIVILEGE privilege_name ROLE role_name [DATABASE database_name] [TABLE table_name]

Privileges

USERADMIN

Description

Use this command to add a new privilege_name to an existing role. The privilege_name parameter can be a list of comma-separated privileges. You can further restrict this operation by specifying a database_name and/or a table_name.

Return

OK string or error value (see SCSP protocol).

Example

> GRANT PRIVILEGE readwrite ROLE role1
OK