SaveToDB Framework Roles
Role | Description |
---|---|
xls_admins | The role includes permissions for Excel application administrators. |
xls_developers | The role includes permissions for Excel application developers. |
xls_formats | The role includes permissions for saving Excel table formats. |
xls_users | The role includes permissions for Excel application users. |
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.
In this article