Kbase P103913: How will adding the Frozen flag and Table security affect application?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/12/2009 |
|
Status: Verified
GOAL:
How will adding the Frozen flag and Table security effect an application?
GOAL:
How can the Frozen flag and Table security effect an application?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
A table may be frozen without enabling security. The property for Freezing a Table schema in found in the DataAdmin Utilities menu by selecting the Freeze/Unfreeze option. The table _File and field _Frozen are where this property is set, so if permissions are added for specific users for can write, for at least the field _Frozen, one could control who would be allowed to change the Frozen status on a table in order to make schema changes on a table.
The setting of the permissions for standard Tables may be also be flagged in Admin Security for create and delete permissions plus other permissions, but do not have to be set if the only requirement is to prevent unwanted users from changing a tables schema.
In order for these permissions to be invoked, the user must be added to the user list which will result in the users name being entered in the _user table. Once a user has been added to the user list (_user table) the Data Security settings that have been entered or to be added will take effect.
Once users have been added to the _user table a login and password prompt will be generated for each runtime user that logs into the database. If this is not desired behavior at login time then the application will have to be changed to handle them.