Modify Authorizations, Table Auths by Table (ttams3242m000)

Use this session to modify the database table authorizations at table level. For example, to change the modify or read authorization of a user that is linked to the role to read-only in the Pricing Parameters table in Tools Distribution.

In this session you can:

  • Define the companies in which the database table authorizations at table level must be modified.
  • Define the packages in which the database table authorizations at table level must be modified.
  • Define the tables for which the database table authorizations must be modified.
  • Define the old and new database table authorizations.

Click Modify to start the process.

Field Information

All Companies

If this check box is selected, the authorizations are modified for all companies.

If authorizations are defined for a specific company as well as for all companies, they can overlap. The authorizations for a specific company have the highest priority. If you want to define the authorizations for a specific company, you must define the company in the following field.

Company

Specifies the code of the company for which the database table authorizations at table level are modified.

Company

Specifies the code of the company for which the database table authorizations at table level are modified.

Package

Specifies the code of the package for which the database table authorizations at table level are modified.

Package

Specifies the code of the package for which the database table authorizations at table level are modified.

Table

Specifies the code of the specific table for which the database table authorizations are modified.

Table

Specifies the code of the table for which the database table authorizations are modified.

Authorization

Specifies the old authorizations defined for the database table authorizations in the specified tables. This information is used by the server to determine whether a user is authorized to perform a database action on the tables in the company.

Authorization

Specifies the old authorizations defined for the database table authorizations in the specified tables. This information is used by the server to determine whether a user is authorized to perform a database action on the tables in the company.

New Authorization

Specifies the new authorizations defined for the database table authorizations in the specified tables. This information is used by the server to determine whether a user is authorized to perform a database action on the tables in the company.