SaveToDB Framework Roles

SaveToDB Framework Roles

You have to grant permissions on SaveToDB Framework objects to allow applications to read the configuration.

You can do this by adding users to built-in SaveToDB Framework roles:

  • xls_users
  • xls_formats
  • xls_developers

The xls_users role has permissions to read the configuration.

The xls_formats role has permissions to save table formats to the xls.formats table.

The xls_developers role has permissions to read and write the configuration.

Managing User Roles

You can use the context menu of the xls.users view or SQL commands show below to add or remove roles.

SQL Server | MySQL | PostgreSQL | Oracle | DB2 | NuoDB | 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

To be compatible with MySQL 5.7, SaveToDB Framework for MySQL does not use roles.

You can use the following procedures to grant or revoke permission 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 IBM DB2

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;

Managing User Roles with NuoDB

GRANT XLS.XLS_USERS TO SAMPLE02_USER3;
GRANT XLS.XLS_FORMATS TO SAMPLE02_USER3;
GRANT XLS.XLS_DEVELOPERS TO SAMPLE02_USER3;

REVOKE XLS.XLS_USERS FROM SAMPLE02_USER3;
REVOKE XLS.XLS_FORMATS FROM SAMPLE02_USER3;
REVOKE XLS.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;