Skip to main content
Skip table of contents

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.




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.