Kbase P145108: How to prevent disable triggers command for a table and yet have write access to the table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/22/2009 |
|
Status: Unverified
GOAL:
How to prevent disable triggers command for a table and yet have write access to the table?
GOAL:
How to find a way of logging if data changes by a user who has both write access to the table and is a Sec Admin for the database?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
It is not possible to prevent the disable triggers command for a table and yet have write access to it.
Since the goal is to find a way of logging if data changes by a user who has both write access to the table and is a Sec Admin for the database, the recommendation would be to utilize our Auditing functionality to achieve this goal.
Set your auditing permissions right and you'll need a conspiracy of 4 instead of a single rogue admin to wipe out traces of data being changed.