Kbase P96606: How to access the change/display data security utility?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to access the change/display data security utility?
GOAL:
How to restrict database table read?
GOAL:
How can I restrict table read access?
GOAL:
How can I restrict table write access?
FIX:
To be able to modify table and field permissions, a user ID must be designated as a security administrator and be included in each of the individual table and field permissions.
Follow the following steps to set table or field permissions.
1. Access the data dictionary in character interface.
2. Chooe Admin -> Security -> Edit Data Security. The Edit Data Security dialog box appears. Progress alphabetically lists the tables defined for the working database. Choose the table for which you want to specify permission. The Edit Data Security dialog box appears.
3. Choose the table or field for which you want to specify permissions. Press the enter key.
4. Tab over to the Modify tab.
5. Specify the security permissions for the table or field.
6. The six levels of security permissions for a table are:
- Can-Read: specifies the users who have permission to read the table. An asterisk indicates that all users are authorized to read a table. If, instead of an asterisk, the permission value is sales, then only users with a user ID of sales can read the table.
- Can-Write: lists the users who can write to a table or update records.
- Can-Create: specifies the users who can create new records. The user with Can-Create privileges automatically has Can-Write privileges.
- Can-Delete: specifies the users who can delete records from a table.
- Can-Dump: lists the users who can dump database or table definitions and data.
- Can-Load: lists the users who can load database or table definitions and data.
7. Press F1 to save your changes.
8. Press F4 to navigate to select NextField, PrevField, ForwardTable, BackwardTable, SwitchTable, JumpField, Exit.
9. Any changes you make to the table permissions do not affect the current session or any other changes. This means that if other users are working while changes are made to table permissions, they are not affected. To use the new permissions, you must exit and restart Progress.