SaveToDB Framework Roles

xls_admins

The role includes permissions for Excel application administrators.

Assign this role to business users who can manage user permissions.

The role grants EXECUTE permissions on stored procedures used to manage and change permissions.
However, they execute the code under the actual user permissions.
So, a user can change permissions if he has permissions on such operations.

Members of the xls_developers role also have permissions to execute these procedures as they are in the xls schema.

xls_developers

The role includes permissions for Excel application developers.

Assign this role to developers and advanced users who can customize Excel applications.

Members of this role have permissions to read and write the configuration of the SaveToDB Framework used to configure SaveToDB add-in features.

See actual database permissions in the xls.xl_actions_set_role_permissions procedure.

xls_formats

The role includes permissions for saving Excel table formats.

Assign this role to end-users of Excel applications to allow saving Excel table formats into the xls.formats table.

Users may use SaveToDB Table Format Wizard or the Save Table Format menu item to save formats.

Members of the xls_developers role have this permission by default.
See actual database permissions in the xls.xl_actions_set_role_permissions procedure.

This role was added in SaveToDB Framework 8.11.

xls_users

The role includes permissions for Excel application users.

Assign this role to end-users of Excel applications.

Members of this role have permissions to read the configuration of the SaveToDB Framework used to configure SaveToDB add-in features.

See actual database permissions in the xls.xl_actions_set_role_permissions procedure.