GRANT
GRANT privileges
Syntax
GRANT
SQL
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
SQL
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.