Kbase P110968: How will adding Table security affect an application?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2008 |
|
Status: Verified
GOAL:
How will adding Table security affect an application?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
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 does 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 added in the future 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.