Kbase P7015: Where is the user and table security information stored
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2010 |
|
Status: Verified
GOAL:
Where is the user and table security information stored
GOAL:
How to modify or revoke secutiry setting outside of the data dictionary
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
When users are added to a Progress database all the information is stored in the _user table. Passwords are encoded and there is no direct 4GL instruction to unencode them.
However, when data security is defined for tables and fields, other tables are involved. Basically the _file table stores the information about the table permissions and the _field table stores the respective information for the fields but these tables should not be modified directly using 4GL.
Use the appropriate option from the Data Administration tool:
[DataAdministration] -> <Admin> -> <Security> -> <Edit Data Security>