|
| ||||||||||||||||||
 |  |  |  |
This section describes how to create and grant user access permissions to your data using the Easysoft Web Administrator provided with the Easysoft SQI-Sage Tetra CS/3 Driver.
The Web Administrator utility allows you to limit the access that people have to your data by creating users for a data source and specifying their access rights to the data within that data source.
This allows individual users to be prevented from editing, deleting or viewing certain files and tables.
To run the Web Administrator it is necessary to start the Web Administrator server and then connect to it from a web browser.
1. Log onto the server machine as the root user.
2. Change into the <InstallDir>/easysoft/sqi/tetra directory.
Accept the default port (8450) or specify another unused port.
4. Run a Web browser on the machine from where you want to manage your users, and go to http://server:8450 (where server is the name or IP address of the machine on which the Easysoft SQI-Sage Tetra CS/3 Driver is installed and 8450 is the port at which the Web Administrator is listening).
For example, if the Web Adminstrator is running on the local machine, type:
The main screen of the Web Administrator displays a list of the data sources which have been configured in the <InstallDir>/easysoft/etc/odbc.ini file for use with the Easysoft SQI-Sage Tetra CS/3 Driver (see Creating additional data sources for details of how to set up multiple Sage Tetra CS/3 data sources):
If you ever need to stop the Web Administrator, change into the <InstallDir>/easysoft/isam/bin directory whilst logged on as root and run ./stop_http.sh.
You should only ever need to restart the Web Administrator if the server fails or if you want to start it on another port.
To set up user access and grant rights to tables, you must log on to the Web Administrator as 'manager' and enter the manager password.
You are required to log on when you click Users, Access Rights or Reports for the first time in a Web Administrator session, and again if you select a different data source or change the manager password.
When asked to log on for the first time, enter:
Once you are logged on, the first thing you should do is change the manager password.
1. Click Users to display a list of Sage Tetra CS/3 users.
2. Enter a new manager password in the Password box and the old manager password in the Old Password box (you must enter your old password or the new password will not take effect).
The new manager password is saved.
| The manager user automatically has access to all Sage Tetra CS/3 data sources and tables. |
You can specify which users have access to Sage Tetra CS/3 data via the Easysoft SQI-Sage Tetra CS/3 Driver and you can set up a password for each user to prevent any unauthorized access.
1. Log on to the Web Administrator as described in Logging on to the Web Administrator.
2. Click Users (you must log on as manager if you have not already done so) to see a list of the users which are currently set up.
3. Select the data source and company for which you want to specify user access.
The Web Administrator lists only companies that contain data, so if you have set up a new company and it is still blank, the Web Administrator does not list it.
Whenever you select a different data source or company, click Refresh to update the remainder of the page to ensure that you are viewing the correct data for that selection.
4. In the list of users, set Allow Access to Yes for the users that need access to the selected data source.
When first enabled, a user has access to all companies within the same data source but no access to any tables within any company. Click Access Rights to grant access to tables.
See Granting access to tables for more information.
5. Set a password for each user to whom you have enabled access.
Leave the Password box empty if you do not want to set a password for a particular user.
6. Click Submit to confirm the users and passwords that you have set up:
Once a user has access to a Sage Tetra CS/3 data source you can specify precisely which tables within that data source to which the user will be allowed access (see Granting access to tables).
| If the access of a user to a data source is disabled then any rights they have been granted are lost, so that if you later enable that user again, you will need to grant their rights again. |
You choose which tables a user has access to for each specific Sage Tetra CS/3 data source.
If a data source contains more than one company, you can specify different access rights for each company within the same data source.
For example, you can prevent a user from having any access to one particular company by revoking their rights to all the tables belonging to that company, but still give them access to the tables of another company.
You can set access rights by granting access to all tables, to specific tables, or based on key directories, which are used by Sage Tetra CS/3 to group tables into categories.
For example, all tables beginning with "POP_" are found in the POFILESDD key directory.
| A user must have access to the selected data source before you can grant them rights to particular tables. Click Users to enable the access of a user to a data source. |
To grant a user access to specific data source tables:
1. Log on to the Web Administrator (see Logging on to the Web Administrator).
2. Click Access Rights (you must log in as manager if you have not already done so).
Choose the data source and company for which you are granting access.
3. Choose the user for whom you want to grant access (select Public to make tables accessible to all users).
The tables to which this user has access in the selected company are listed on this page.
Whenever you select a different data source, company or user, click Refresh to update the remainder of the page to ensure that you are viewing the correct data for that selection.
4. To grant access to tables according to their key directory, click Key Directory.
A list box containing the available key directories becomes available. Select the key directory to which you want to grant access, then click Grant.
Repeat this step to grant access to any other key directory.
To remove the access for a user to a particular key directory, select it from the list box then click Revoke.
5. To grant access to tables individually, click By Table.
The tables are listed alphabetically in the Available Tables drop-down list box. Select a table from this list box and then click Grant. To remove the access for a user to a table, select it from the list box and then click Revoke.
If the selected company has not been set up within Sage Tetra CS/3, the Available Tables drop-down list box will show 'No Tables Found'.
6. To grant the user access to all tables in the selected company, click Grant All. To remove the user's access to all tables, click Revoke All.
7. You can remove the access for a user to particular tables by clicking the Revoke box in the list of tables and then clicking Revoke Selection.
The tables to which the current user has access are listed here:
The Web Administrator provides some reports which you can run on your own Sage Tetra CS/3 data, such as to check that the Easysoft SQI-Sage Tetra CS/3 Driver has been installed correctly on your server and that your Sage Tetra CS/3 data is being accessed.
1. Log on to the Web Administrator as described earlier.
3. Select the data source and company on which you want to run the report.
The reports available are listed on this page.
Whenever you select a different data source or company, click Refresh to update the remainder of the page to ensure that you are viewing the correct data for that selection.
4. Click View for the report that you want to run.
The page refreshes to display the report results.
| Copyright Notice |
| | | |
