Queries Maintaining Lookup and Support Tables

Admin


 

Admin, or Administration is generally reserved for Security, but it might also be used for table maintenance for tables that have user restrictions. While the base system of TCSW does not contain any security, it is possible to attain any level of security that you desire. For example, you can restrict users with Password and Logon access. You can set up security levels for users to restrict their ability to edit tables, allowing them read-only access and the ability to print reports. You can show different menus and different buttons to different users, or show menu choices grayed out indicating that they are inaccessible. You can control security to any level you wish by working with Data Control and Management. Some samples of security access are shown below:

 

Generate/ADMIN1.gif

 

In the above sample, a simple password screen restricts general access to the application. You could use this to prevent access to unauthorized users without developing an elaborate security scheme.

 

Generate/ADMIN2.gif

 

In the sample above, user rights are determined by the user's name and password. For example, Bob has rights to only the File and Help menu choices, and he sees a menu such as this:

 

Generate/ADMIN3.gif

 

However, Linda can do Data Entry and print reports for accounting functions, so she sees the menu below:

 

Generate/ADMIN4.gif

 

However, some of the choices on her Data Entry menu are grayed out, and the reports menu only shows two reports choices when there are really three reports available. She can see the Security menu choice, but when she tries to access it, a message tells her that she does not have access rights.

 

Generate/ADMIN5.gif

 

In the sample above, the "bosses" don't have any data entry choices, but they can access Security. When they do, they see the form below that allows them to change the Security levels for the various users of the system:

 

Generate/FH469330.gif

 

Security Levels

 

There are currently 12 levels of Security in TCSW - enough for most applications. The Security Level and Values are shown in order from lowest to highest security level below:

 

Generate/FH469451.gif

 

Security Module Access

 

It's also possible to restrict access to specific modules. As an administrator, you can restrict access to each module by placing True or False in the appropriate module field. In the sample below, users 1 and 2 have access to all modules, but user 3 is limited to the Tracing Module only.

 

Generate/FH469702.gif

 

Security Table Access

 

Finally, it is possible to restrict users from viewing certain tables within a module. In the sample below, user 3 has "specific" table access denoted by SPC (the alternative is blank or ALL). In this case, user 3 will only see the Current Sightings grid in the Tracing Module grid. When they attempt to access another table, they will get a message that their access is restricted to Current Sightings and the requested grid will appear blank to them. In the current system, it is possible to determine specific table access for up to 20 tables in TCSW.

 

NOTE: While all of these scenarios are perfectly possible in TCSW, in most cases custom programming will be required to achieve high levels of security control. Talk to Data Control and Management for details.

 

Generate/FH470237.gif

 

 



Contents Queries Maintaining Lookup and Support Tables