| Table Field Authorizations (ttams3143m000) |  |
| Use this session to maintain database table authorizations at a table field level. This means that you can restrict the normal user who is linked to the role to fields of a specific table. Only if the user has at least Read authorization for the table, database table-field authorizations are meaningful. Database table-field authorizations only work for sessions with a main table. For example, Maintain sessions and Display sessions. If a user has no authorization to modify a field, the field is disabled. If a user has no authorizations at all, the No Authorization Character, which is defined in the Maintain Parameters (ttaad0100m000) session, is displayed. Database table field authorizations have no effect on reports. Update sessions, when fields are automatically filled by the session, will also ignore database table-field authorizations. If you do not specify database table-field authorizations, the user will have the database table authorizations. You can define exceptions to the database table-field authorizations at table-field data level in the Table Field Data Authorizations (ttams3146m000) session. You can use the Specific menu to: Modify the database table-field authorizations for a range of table fields Copy a range of table fields in the current role Delete the database table-field authorizations for a range of table fields Convert the changes of the database table authorizations to the run-time data dictionary. The database authorization data of the role is stored in the $BSE/lib/db/<first character of role>/<role>. Related topics To use an overview session To maintain records in an overview session
Fields | Description
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-field authorizations are defined.
Company | No Help topic is associated with this item.
Field Name | Specifies the table field for which the database table field authorizations are defined.
Description | The description of the table field.
Authorization | Specifies the possible table field authorizations.