Table rights

A table right is the right that a usergroup of an application has to access a table of that application (called Authorization Table).

Each individual table right gives access in precisely one of five (5) access modes:

The first four (4) access modes (SELECT, INSERT, UPDATE, DELETE) are mutually exclusive. ALL is a shortcut for the combination of SELECT, INSERT, UPDATE and DELETE. Having an ALL table right is the equivalent of having the other 4 specific Table Rights.

In addition to access mode, the effect of each Table Right is determined by its scope.

IMPORTANT 1: By default, in USoft Authorizer, a user has full access to all tables as long as no specific Table Rights or Column Rights are introduced for that user. Be aware that introducing the first Table Rights will bar access to any other tables unless you specifically define Table Rights for those tables as well.

IMPORTANT 2: Once you start defining Table Rights, you will also need to tell the database to generate grants corresponding to these rights.

To define a table right:

1.	Choose Define, Table Rights.

The Table Rights window appears.

2.	Complete the dialog as follows:

•Type the names of the application and user group for which you want to define access rights, in the Application and User Group fields. Lookup buttons are available for both fields.

•Enter the table name in the Table Name field, and then, in the Access Right field, specify which right you want to grant at the table level. Lookup buttons are available for both fields.

•Click the Scope button to choose Foreground And Background, Background Only, or None from the dropdown list.

•If any (previously defined) conditions apply to the foreground, and background rights, use the Lookup buttons in the Frgrnd Condition ID, and Bckgrnd Condition ID fields to enter their IDs.

•In the Extra Column Rights tab page, enter the details for the various columns, if you want to further enhance or restrict the rights granted at table level.

3.	Save your changes.