Table Rights

Previous Next

A table right is the right that a specific user group of a specific application has to access a specific table of that application (called Authorization Table).

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

SELECT

INSERT

UPDATE

DELETE

ALL

The first four (4) categories (SELECT, INSERT, UPDATE, DELETE) are mutually exclusive.

ALL is a shortcut for the combination of SELECT, INSERT, UPDATE and DELETE: an ALL table right is the equivalent of the combination of these four specific Table Rights.

Each Table Right has a Scope setting that is normally "Foreground and background".

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 table rights:

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.

 

See Also

Column Rights

Authorization Tables

Scope

Authorization concepts

Database grants