Click on the menu Edit / Settings to open the Settings screen.
The section General Settings deals with the locations of the various configuration files and the level of security Sequenchel uses. Sequenchel does not distinguish between users so you will need a seperate installation for every set of security settings.
Default Config File Path: The path used for all files, unless you specify a different path per file.
Settings File: The path and file name of the General Settings file.
Connections File: The path and file name for the file that will hold all configured connections.
The Thicor logo button provides a default value for the setting next to it.
In the file paths you can use the following variables:
- %Documents% : The users My Documents folder
- %ProgramFiles% : The Program Files folder
- %ApplicationData% : The Application data folder for the current users
- %CommonApplicationData% : The Application data folder for all users
- %Desktop% : The desktop off the currently logged on user
The security section allows you to configure what actions users are allowed to perform.
- Allow Settings change: This privilege gives the user access to the Settings screen and the power to change all settings. If anyone other than the DBA works with Sequenchel, you should uncheck this checkbox.
- Allow Configuration Change: The user can add / alter / delete configurations, including connections, tablesets and tables. If you wish to allow a user to create new connections to databases, leave this checkbox checked.
- Allow Linked Server Change: Sequenchel relies on Linked Servers to monitor SQL Servers and databases. For reporting only, you can uncheck this checkbox. This functionality is only required for the DBA.
- Allow Report Query Edit: The user can create a report definition, but manually alter the resulting query completely. If you wish to avoid update or insert queries, uncheck this checkbox. unchecking this checkbox also disables the option to load custom queries in the report query section.
- Allow Data Import: This enables the user to import a text (*.txt; *.csv), XML (*.xml) or Excel (*.xls; *.xlsx) file into the database or convert and export it to any of the other supported file types.
- Allow SmartUpdate Configuration: This enables the user to set up SmartUpdate and transfer data from any source database to a local SQL Server database.
- Allow Update: This privilege gives the user the option to perform updates on a database or table, if the configuration allows this also. If a user can configure his own connections but should not be allowed to make any changes, uncheck this checkbox.
- Allow Insert: This privilege gives the user the option to perform inserts on a database or table, if the configuration allows this also. If a user can configure his own connections but should not be allowed to make any changes, uncheck this checkbox
- Allow Delete: This privilege gives the user the option to perform deletes on a database or table, if the configuration allows this also. If a user can configure his own connections but should not be allowed to make any changes, uncheck this checkbox
The Override Password option can be used to specify a password to override the security settings as specified on this page. If the user starts Sequechel with the command line parameter
/securityoverride:yourpassword, all actions are allowed. This gives the DBA the possibility to add connections or change configuration settings without allowing users to (temporarily) make changes to databases.
Close Sequenchel after x hours of inactivity. Sequenchel can be installed on a network share and used by many users simultaniously. This does pose a challenge for updates, especially if users don’t close Sequenchel before they leave for home. With this setting, you can ensure that after, for instance, 8 hours of inactivity Sequenchel closes. 0 hours disables this setting.
You can choose the date format for displaying datetime values on the screen and exports to files. You can also have the date, in that format, included in the filename for exported files. This setting is also used when exporting files through the command line interface.
The default limit for lookup value lists is 100. We recommend you keep this value as is.