 |
|
|
 | Server List on the Control Panel |  | Control Panel | Local Settings Folder |  |
The System folder allows:
Double-click this folder to open a dialog window that allows you to specify 602SQL Server parameters. This window is described on the page Runtime Parameters dialog.
You may specify the set of communication protocols for the selected 602SQL server. More information can be found on the page Dialog Protocols and Ports.
You will find important database components that are common for all applications in the System / System objects folder. Click on the individual types for more information.
 | Users | Privilege subjects (same as a group) defined in the database context. Privileges are modified for individual applications using roles. |
 | Groups | Sets of users that have the same privileges. A privilege granted to a group is assigned to all members of this groups. |
 | System tables | Special tables of the 602SQL Server core that stores information about database tables (TABTAB), other objects (OBJTAB) and users and groups (USERTAB). |
System tables cannot be edited directly from the Control Panel (they can be opened, and only some columns can be changed).
You can restore objects that were deleted by accident. There is the Deleted? checkbox in the first grid column. This checkbox may have three values: not checked=valid record, checked=deleted record, that can be restored, gray=dropped record, that cannot be restored. You can restore deleted records by unchecking the checkbox. The restored record will appear on the Control Panel when it is refreshed.
BEWARE: Deleted records are not used in queries. You cannot search for the record by sorting the grid or restricting the grid with some condition.
Tools and utilities from this section are opened by double-clicking them.
You can set parameters to automatically backup the database file. More information about backups can be found on the page How to create a complete database backup.
You can send a short message to other network clients from this dialog (e.g. to let them know to finish their work, because an upgrade is scheduled, etc.).
You can check database consistency here. If errors exist you can attempt to repair them. More information about consistency checks may be found on the page Checking database consistency. Consistency repair (not the consistency check) requires the server to be locked (no user can be connected).
You can choose the encryption type and encrypt the database. More information can be found on the page Protecting database against intruder attacks.
This tool allows you to generate a certificate or import an external certificate from a file. More information about certificates can be found on the Verifying 602SQL Server identity on a network.
It may be necessary to modify the name or binary identification of the 602SQL Server. You have to restart the server after the modification! If you change the server identification all user passwords will be invalid. More information about server identification can be found on the page Server name, address and identity
This utility exports all users and groups from the database (including relations) to a file. This can be used to import these subjects into another database. More information can be found on the page Export and import of all users.
This utility imports users and groups from a file into the database.
You may enable runtime profiling and watch the results here. More information can be found on the 602SQL Server runtime profiling page.
This toll allows you to activate commercial server extensions.
The parameters of the Web XML Interface can be set here as well as a functionality verification - details on the Put Web XML interface into Operation page. It is not a component part of the English documentation as yet.
List of topics:
| Server List on the Control Panel | | Control Panel | Local Settings Folder | |