[Stackoverflow] [Progress OpenEdge ABL] How to add a lot of tables to the OpenEdge PSC-App-Tables auditing policy?

Status
Not open for further replies.
E

Ezequiel

Guest
we have added a group of tables of our OpenEdge database, to the PSC default policy. And it went really good for more than a year.

Now our new CIO wants every table of the database to be included.

We tried to disuade him, we explained, but....

So, there is a lot of tables. I'm looking a way to add them without typing everything.

I created an XML file with all the new tables, using the same format and tried to import it as a new policy. But the Audit Policy Maintenance doesn't accept it. The error message is The file C:\Tmp\archivos-agregar.xml has changed since it was exported or it does not contain the seal information.

Of course it doesn't, I made it.

And here I am right now, asking for ypur help. Is there a way to enter a lot of tables in this policy?

This is a sample of the XML file:

Code:
    ***<?xml version="1.0" encoding="UTF-8"?>
    <Policies>
      <Policy GUID="Mercadeo" Name="PSC-App-Tablas">
        <policy-properties>
          <_Audit-policy-description>Database record CUD operations</_Audit-policy-description>
          <_Audit-data-security-level>0</_Audit-data-security-level>
          <_Audit-custom-detail-level>0</_Audit-custom-detail-level>
          <_Audit-policy-active>YES</_Audit-policy-active>
        </policy-properties>
    <audit-table Name="admaplic" Owner="PUB">
    <_Audit-create-level>2</_Audit-create-level>
    <_Create-event-id>5100</_Create-event-id>
    <_Audit-update-level>3</_Audit-update-level>
    <_Update-event-id>5101</_Update-event-id>
    <_Audit-delete-level>2</_Audit-delete-level>
    <_Delete-event-id>5102</_Delete-event-id>
    </audit-table>
    
    (lot of files here)
    
    <audit-table Name="xopeprodalm" Owner="PUB">
    <_Audit-create-level>2</_Audit-create-level>
    <_Create-event-id>5100</_Create-event-id>
    <_Audit-update-level>3</_Audit-update-level>
    <_Update-event-id>5101</_Update-event-id>
    <_Audit-delete-level>2</_Audit-delete-level>
    <_Delete-event-id>5102</_Delete-event-id>
    </audit-table>
        <audit-event Event-id="5100">
          <_Event-level>1</_Event-level>
          <_Event-criteria></_Event-criteria>
        </audit-event>
        <audit-event Event-id="5101">
          <_Event-level>1</_Event-level>
          <_Event-criteria></_Event-criteria>
        </audit-event>
        <audit-event Event-id="5102">
          <_Event-level>1</_Event-level>
          <_Event-criteria></_Event-criteria>
        </audit-event>
        <audit-event Event-id="32000">
          <_Event-level>2</_Event-level>
          <_Event-criteria></_Event-criteria>
        </audit-event>
      </Policy>
    </Policies>***

Continue reading...
 
Status
Not open for further replies.
Top