Table Authorizations by Table (ttams3142m000)
Use this session to maintain the database table authorizations at table level per role. This means that the users that are linked to the role can be restricted to specific database actions on records of tables in a specific table.
You can define the database table authorizations for all companies or for a specific table. The authorizations for the specific company have the highest priority in this case.
You can define what actions are permitted for the database table. For example, insert, delete, modify, and so on.
The database table authorizations at table level are an exception to the database table authorizations at company level, at package level, and at module level. You can maintain exceptions of the database table authorizations at table level and at table-data level by using the Table Data Authorizations (ttams3145m000) session.
You can use the appropriate menu to:
- Modify the authorizations for a range of tables
- Copy a range of tables in the current role
- Delete the authorizations for a range of tables
- Convert the changes of the database table authorizations to the run-time data dictionary
Field Information
- Role
-
Specifies the code of the role.
- Role
-
The description of the role.
- All Companies
-
If this check box is selected, the authorizations are defined 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.
- Company
-
Specifies the code of the specific company for which the database table authorizations at table level are defined.
- Company
-
The description of the module.
- Package
-
Specifies the code of the package for which the database table authorizations are defined.
- Package
-
The description of the package.
- Table
-
Specifies the code of the module for which the database table authorizations at table level are defined.
- Table
-
Specifies the code of the table for which the database table authorizations are defined.
- Description
-
A description of the table.
- Authorization Indicator
-
Specifies the type of authorization that is defined for the database table authorizations in the specified table. This information is used by the server to determine whether a user is authorized to perform a database action on the tables.