GRANT

GRANT privileges

Syntax

GRANT privilege_type [, privilege_type ] ... 
    ON my_data_space	TO principal_specification [, principal_specification] ... ;

privilege_type

INSERT | SELECT | DELETE | ALL

There is no UPDATE command.

principal_specification

ROLE | USER followed by name of the role/user.

Granting to a new role will implicitly create a new role.

GRANT Roles

Grant one or more roles to other roles or users.

Syntax

GRANT role_name [, role_name] TO USER user_name [, user_2];

role_name

Name of the role you want to add.

user_name

Name of the user you want to assign the role to.

Predefined roles

INDEXIMA already have 2 pre-defined roles:

• admin : Grant all on all data spaces.
• public : All users are in the public role.

Granting to a new role will implicitly create a new role.