Kbase P113662: Can auditing be used on metaschema tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/8/2009 |
|
Status: Verified
GOAL:
Can auditing be used on metaschema tables?
GOAL:
Can auditing be used on system tables such as _File, _Table?
FACT(s) (Environment):
OpenEdge 10.1A
FIX:
Yes, auditing of metaschema tables is possible.
If you load the default auditing policies (DLC/auditing/policies.xml contains the loaded policies), you see entries for the metaschema (under APP-SCHEMA are entries for _File etc.).
There is also the 4GL "audit policy maintenance" tool which allows maintaining policies on tables. Because the policies are stored in _audit...-tables in the PUB-schema, you should be able to enter policies in any other SQL-schema (any other user-schema or system-schema).