Kbase P117507: Userid is not visible within Auditing reports
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/19/2008 |
|
Status: Verified
SYMPTOM(s):
Userid is not visible within Auditing reports.
No userid listed for users connecting locally or remotely.
Auditing correctly enabled.
User is listed in the _user table.
Disallow blank users set in Data Administration / Dictionary tool.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
CAUSE:
In the Data Administration (Windows) / Dictionary tool (Unix) an option exists under the Admin menu named Database Options which turns on "Use Application User Id for Auditing".
Once enabled this setting triggers the Progress Auditing to expect 4GL statements within an application to set the Userid.
This disables the default setting of Userid from within Progress for auditing.
FIX:
If the application working with the Progress database is not programmatically setting Userid do not enable the "Use Application User Id for Auditing" option within the Database Options section of the Admin menu options as this will stop userids from being passed to the Auditing portion of the Progress database code.