Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Preconfigured Audit Policies : Using the preconfigured OpenEdge audit policies
 

Using the preconfigured OpenEdge audit policies

By importing the predefined OpenEdge database audit policies, you can audit the events listed in the following table. For more information, see the Audit Policy Maintenance Help.
Event ID
Event name
Event type
Event description
Policy name
100
_sys.user.create
Security
User account created
PSC-UserAccounts
101
_sys.user.update
Security
User account updated
PSC-UserAccounts
102
_sys.user.delete
Security
User account deleted
PSC-UserAccounts
210
_sql.dba.create
Security
SQL DBA created
PSC-Security
211
_sql.dba.update
Security
SQL DBA updated
PSC-Security
212
_sql.dba.delete
Security
SQL DBA deleted
PSC-Security
300
_sys.audit.policy.create
Audit
Audit policy record created
PSC-Audit
301
_sys.audit.policy.update
Audit
Audit policy record updated
PSC-Audit
302
_sys.audit.policy.delete
Audit
Audit policy record deleted
PSC-Audit
400
_sql.tbl.priv.create
Security
SQL table privilege created
PSC-Security
401
_sql.tbl.priv.update
Security
SQL table privilege updated
PSC-Security
402
_sql.tbl.priv.delete
Security
SQL table privilege deleted
PSC-Security
410
_sql.col.priv.create
Security
SQL column privilege created
PSC-Security
411
_sql.col.priv.update
Security
SQL column privilege updated
PSC-Security
412
_sql.col.priv.delete
Security
SQL column privilege deleted
PSC-Security
420
_sql.seq.priv.create
Security
SQL sequence privilege created
PSC-Security
421
_sql.seq.priv.update
Security
SQL sequence privilege updated
PSC-Security
422
_sql.seq.priv.delete
Security
SQL sequence privilege deleted
PSC-Security
500
_sys.auth.sys.create
Security
Authentication system created
PSC-Security
501
_sys.auth.sys.update
Security
Authentication system updated
PSC-Security
502
_sys.auth.sys.delete
Security
Authentication system deleted
PSC-Security
505
_sys.auth.domain.create
Security
Authentication domain created
PSC-Security
506
_sys.auth.domain.update
Security
Authentication domain updated
PSC-Security
507
_sys.auth.domain.delete
Security
Authentication domain deleted
PSC-Security
510
_sys.role.create
Security
Role definition created
PSC-Security
511
_sys.role.update
Security
Role definition updated
PSC-Security
512
_sys.role.delete
Security
Role definition deleted
PSC-Security
515
_sys.role.assign.create
Security
Role assignment created
PSC-Security
516
_sys.role.assign.update
Security
Role assignment updated
PSC-Security
517
_sys.role.assign.delete
Security
Role assignment deleted
PSC-Security
5000
_sys.tbl.create
Schema
Table created
App-Schema
5001
_sys.tbl.trig.create
Schema
Table trigger created
App-Schema
5002
_sys.fld.create
Schema
Table field created
App-Schema
5003
_sys.fld.trig.create
Schema
Table field trigger created
App-Schema
5004
_sys.index.create
Schema
Table index created
App-Schema
5005
_sys.index.fld.create
Schema
Table index field created
App-Schema
5010
_sys.tbl.update
Schema
Table updated
App-Schema
5111
_sys.tbl.trig.update
Schema
Table trigger updated
App-Schema
5012
_sys.fld.update
Schema
Table field updated
App-Schema
5013
_sys.fld.trig.update
Schema
Table field trigger updated
App-Schema
5014
_sys.index.update
Schema
Table index updated
App-Schema
5015
_sys.index.fld.update
Schema
Table index field updated
App-Schema
5020
_sys.tbl.delete
Schema
Table deleted
App-Schema
5021
_sys.tbl.trig.delete
Schema
Table trigger deleted
App-Schema
5022
_sys.fld.delete
Schema
Table field deleted
App-Schema
5023
_sys.fld.trig.delete
Schema
Table field trigger deleted
App-Schema
5024
_sys.index.delete
Schema
Table index deleted
App-Schema
5025
_sys.index.fld.delete
Schema
Table index field deleted
App-Schema
5030
_sys.seq.create
Schema
Sequence created
App-Schema
5031
_sys.seq.update
Schema
Sequence updated
App-Schema
5032
_sys.seq.delete
Schema
Sequence deleted
App-Schema
5040
_sys.db.prop.create
Schema
Database property created
App-Schema
5041
_sys.db.prop.update
Schema
Database property updated
App-Schema
5100
_sys.db.rec.create
Data
Database record created
PSC-App-Tables
5101
_sys.db.rec.update
Data
Database record updated
PSC-App-Tables
5102
_sys.db.rec.delete
Data
Database record deleted
PSC-App-Tables
10000
_sys.db.audit.enable
Audit
Database auditing enabled
PSC-Audit
10001
_sys.db.audit.disable
Audit
Database auditing disabled
PSC-Audit
10010
_sys.audit.policy.commit
Audit
Audit policy run-time update
PSC-Audit
10100
_sys.db.start
Admin
Database started
PSC-DB-Admin
10101
_sys.db.stop
Admin
Database stopped
PSC-DB-Admin
10202
_sys.bindump
Utility
Database binary dump
PSC-DB-Admin
102031
_sys.binload
Utility
Database binary load
PSC-DB-Admin
10204
_sys.copy
Utility
Database copy
PSC-DB-Admin
102052
_sys.tbl.move
Utility
Database table move
PSC-DB-Admin
102063
_sys.idx.move
Utility
Database index move
PSC-DB-Admin
10207
_sys.idx.check
Utility
Database index check
PSC-DB-Admin
102084
_sys.idx.rebuild
Utility
Database index rebuild
PSC-DB-Admin
10209
_sys.area.truncate
Utility
Database area truncate
PSC-DB-Admin
10211
_sys.sql.dump
Utility
Database SQL dump
PSC-DB-Admin
10212
_sys.sql.load
Utility
Database SQL load
PSC-DB-Admin
10213
_sys.txt.dump
Utility
Database text dump
PSC-DB-Admin
10214
_sys.txt.load
Utility
Database text load
PSC-DB-Admin
102155
_sys.index.activation
Utility
Database index activation
PSC-DB-Admin
102166
_sys.index.deactivation
Utility
Database index deactivation
PSC-DB-Admin
102177
_sys.db.deallocate
Utility
Deallocate a table instance
PSC-DB-Admin
10300
_sys.audit.archive
Audit
Audit archive
PSC-Audit
10301
_sys.audit.data.dump
Audit
Audit data dump
PSC-Audit
10302
_sys.audit.data.load
Audit
Audit data load
PSC-Audit
10303
_sys.audit.pol.dump
Audit
Audit policy dump
PSC-Audit
10304
_sys.audit.pol.load
Audit
Audit policy load
PSC-Audit
10305
_sys.audit.recoveradmin
Audit
DBA deleted last audit admin
PSC-Audit
10500
_pvm.setdbuser.success
User
Database user identity set
PSC-User
10501
_pvm.setdbuser.fail
User
Database user identity failed
PSC-User
10510
_pvm.user.login.pass
User
User login success
PSC-User
10511
_pvm.user.logout
User
User logout
PSC-User
10512
_pvm.user.login.fail
User
User login failed
PSC-User
10520
_sql.user.login.pass
User
SQL user login success
PSC-User
10521
_sql.user.logout
User
SQL user logout
PSC-User
10522
_sql.user.login.fail
User
SQL user login failed
PSC-User
10600
_pvm.db.connect
User
Database connect
PSC-User
10601
_pvm.db.disconnect
User
Database disconnect
PSC-User
10610
_sql.db.connect
User
SQL database connect
PSC-User
10611
_sql.db.disconnect
User
SQL database disconnect
PSC-User
11000
_sys.db.enc.enable
Encryption
Enable Encrypted Database feature
Database Encryption
11001
_sys.db.enc.disable
Encryption
Disable Encrypted Database feature
Database Encryption
11100
_sys.ks.create
Encryption
Create database key store
Database Encryption
11101
_sys.ks.delete
Encryption
Delete database key store
Database Encryption
11102
_sys.ks.open.pass
Encryption
Successful open database key store
Database Encryption
11103
_sys.ks.rekey
Encryption
Change database key store passphrase
Database Encryption
11104
_sys.ks.setcipher
Encryption
Change database key store master key type
Database Encryption
11105
_sys.ks.setadmin.pwd
Encryption
Change database key store administrator passphrase
Database Encryption
11106
_sys.ks.setuser.pwd
Encryption
Change database key store user passphrase
Database Encryption
11107
_sys.ks.ke.create.pass
Encryption
Successful create of database key store entry
Database Encryption
11108
_sys.ks.ke.update.pass
Encryption
Successful update of database key store entry
Database Encryption
11109
_sys.ks.ke.delete.pass
Encryption
Successful delete of database key store entry
Database Encryption
11110
_sys.ks.ke.read.pass
Encryption
Successful read of database key store entry
Database Encryption
11111
_sys.ks.open.fail
Encryption
Failure in database key store open
Database Encryption
11112
_sys.ks.ke.create.fail
Encryption
Failure in database key store entry create
Database Encryption
11113
_sys.ks.ke.update.fail
Encryption
Failure in database key store entry update
Database Encryption
11114
_sys.ks.ke.delete.fail
Encryption
Failure in database key store entry delete
Database Encryption
11200
_sys.as.create.pass
Encryption
Successful database auto-start file create
Database Encryption
11201
_sys.as.delete.pass
Encryption
Successful database auto-start file delete
Database Encryption
11202
_sys.as.open.pass
Encryption
Successful database auto-start file open
Database Encryption
11203
_sys.as.recover.pass
Encryption
Successful database auto-start file recovery
Database Encryption
11204
_sys.as.update.pass
Encryption
Successful database auto-start file update
Database Encryption
11205
_sys.as.open.fail
Encryption
Failure in database auto-start file open
Database Encryption
11206
_sys.as.update.fail
Encryption
Failure in database auto-start file update
Database Encryption
11207
_sys.as.recover.fail
Encryption
Failure in database auto-start file recovery
Database Encryption
11300
_sys.enc.scan
Encryption
Started encryption state scan of database object
Database Encryption
11301
_sys.enc.update
Encryption
Started encryption state migration of database object
Database Encryption
11400
_sys.db.dbpolicy.create
Encryption
Create new version of database security policy
Database Encryption
11401
_sys.db.dbpolicy.update
Encryption
Update database security policy version
Database Encryption
11402
_sys.db.dbpolicy.delete
Encryption
Delete database security policy version
Database Encryption
11500
_sys.db.objpolicy.create
Encryption
Create new version of database object security policy
Database Encryption
11501
_sys.db.objpolicy.update
Encryption
Update database object security policy version
Database Encryption
11502
_sys.db.objpolicy.delete
Encryption
Delete database object security policy version
Database Encryption
11600
_sys.db.pwdpolicy.create
Encryption
Create new database passphrase policy
Database Encryption
11601
_sys.db.pwdpolicy.update
Encryption
Update database passphrase policy
Database Encryption
11602
_sys.db.pwdpolicy.delete
Encryption
Delete database passphrase policy
Database Encryption
117008
_sys.db.mt.enable
Multi-tenancy
Enable multi-tenant database feature with pass/fail info
PSC-Multi-tenancy
117019
_sys.db.mt.disable
Multi-tenancy
Disable multi-tenant database feature with pass/fail info
PSC-Multi-tenancy
1171010
_sys.db.tenant.create
Multi-tenancy
Create tenant in multi-tenant database
PSC-Multi-tenancy
1171111
_sys.db.tenant.update
Multi-tenancy
Update tenant in multi-tenant database
PSC-Multi-tenancy
1171212
_sys.db.tenant.delete
Multi-tenancy
Delete tenant in multi-tenant database
PSC-Multi-tenancy
1171313
_sys.db.group.create
Multi-tenancy
Create group in multi-tenant database
PSC-Multi-tenancy
1171414
_sys.db.group.update
Multi-tenancy
Update group in multi-tenant database
PSC-Multi-tenancy
1171515
_sys.db.group.delete
Multi-tenancy
Delete group in multi-tenant database
PSC-Multi-tenancy
1171716
_sys.db.groupmember.create
Multi-tenancy
Create group member in multi-tenant database
PSC-Multi-tenancy
1171817
_sys.db.groupmember.update
Multi-tenancy
Update group member in multi-tenant database
PSC-Multi-tenancy
1171918
_sys.db.groupmember.delete
Multi-tenancy
Delete group member in multi-tenant database
PSC-Multi-tenancy
31998
_sys.app.context
Application
Application context
Application
31999
_sys.app.eventgroup
Application
Audit event group
Application
32000 and higher
user-defined
User-defined event

1 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

2 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

3 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

4 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

5 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

6 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

7 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

8 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

9 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

10 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

11 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

12 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

13 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

14 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

15 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

16 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

17 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .

18 This event uses multi-tenant data formats in a multi-tenant database. For more information, see Audit data event context .