SaveToDB Framework Roles

To enable applications to read the configuration, you need to grant permissions on SaveToDB Framework objects. This can be done by adding users to the built-in SaveToDB Framework roles:

xls_users: Allows reading the configuration.
xls_formats: Allows saving table formats to the xls.formats table.
xls_developers: Allows both reading and writing the configuration.

Managing User Roles

You can manage user roles using the context menu in the xls.users view or by executing the SQL commands provided below.

SQL Server | MySQL | PostgreSQL | Oracle | Snowflake

Managing User Roles with Microsoft SQL Server

ALTER ROLE xls_users ADD MEMBER sample02_user3;
ALTER ROLE xls_formats ADD MEMBER sample02_user3;
ALTER ROLE xls_developers ADD MEMBER sample02_user3;

ALTER ROLE xls_users DROP MEMBER sample02_user3;
ALTER ROLE xls_formats DROP MEMBER sample02_user3;
ALTER ROLE xls_developers DROP MEMBER sample02_user3;

Managing User Roles with MySQL

For compatibility with MySQL 5.7, the SaveToDB Framework for MySQL does not utilize roles. Instead, use the following procedures to grant or revoke permissions on framework objects.

CALL xls.xl_actions_add_to_xls_users('localhost', 'sample02_user3');
CALL xls.xl_actions_add_to_xls_formats('localhost', 'sample02_user3');
CALL xls.xl_actions_add_to_xls_developers('localhost', 'sample02_user3');

CALL xls.xl_actions_remove_from_xls_users('localhost', 'sample02_user3');
CALL xls.xl_actions_remove_from_xls_formats('localhost', 'sample02_user3');
CALL xls.xl_actions_remove_from_xls_developers('localhost', 'sample02_user3');

Managing User Roles with PostgreSQL

GRANT xls_users TO sample02_user3;
GRANT xls_formats TO sample02_user3;
GRANT xls_developers TO sample02_user3;

REVOKE xls_users FROM sample02_user3;
REVOKE xls_formats FROM sample02_user3;
REVOKE xls_developers FROM sample02_user3;

Managing User Roles with Oracle Database

GRANT XLS_USERS TO SAMPLE02_USER3;
GRANT XLS_FORMATS TO SAMPLE02_USER3;
GRANT XLS_DEVELOPERS TO SAMPLE02_USER3;

REVOKE XLS_USERS FROM SAMPLE02_USER3;
REVOKE XLS_FORMATS FROM SAMPLE02_USER3;
REVOKE XLS_DEVELOPERS FROM SAMPLE02_USER3;

Managing User Roles with Snowflake

GRANT ROLE XLS_USERS TO USER SAMPLE02_USER3;
GRANT ROLE XLS_FORMATS TO USER SAMPLE02_USER3;
GRANT ROLE XLS_DEVELOPERS TO USER SAMPLE02_USER3;

REVOKE ROLE XLS_USERS FROM USER SAMPLE02_USER3;
REVOKE ROLE XLS_FORMATS FROM USER SAMPLE02_USER3;
REVOKE ROLE XLS_DEVELOPERS FROM USER SAMPLE02_USER3;