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
51001 _sys.db.rec.create Data Database record created PSC-App-Tables
51011 _sys.db.rec.update Data Database record updated PSC-App-Tables
51021 _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
102051 _sys.tbl.move Utility Database table move PSC-DB-Admin
102061 _sys.idx.move Utility Database index move PSC-DB-Admin
10207 _sys.idx.check Utility Database index check PSC-DB-Admin
102081 _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
102151 _sys.index.activation Utility Database index activation PSC-DB-Admin
102161 _sys.index.deactivation Utility Database index deactivation PSC-DB-Admin
102171 _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
10602 _pvm.db.conn.fail User Database connect PSC-User
10610 _sql.db.connect User SQL database connect PSC-User
10611 _sql.db.disconnect User SQL database disconnect PSC-User
10612 _sql.db.conn.fail User SQL database connect 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 keystore Database Encryption
11101 _sys.ks.delete Encryption Delete database keystore Database Encryption
11102 _sys.ks.open.pass Encryption Successful open database keystore Database Encryption
11103 _sys.ks.rekey Encryption Change database keystore passphrase Database Encryption
11104 _sys.ks.setcipher Encryption Change database keystore master key type Database Encryption
11105 _sys.ks.setadmin.pwd Encryption Change database keystore administrator passphrase Database Encryption
11106 _sys.ks.setuser.pwd Encryption Change database keystore user passphrase Database Encryption
11107 _sys.ks.ke.create.pass Encryption Successful create of database keystore entry Database Encryption
11108 _sys.ks.ke.update.pass Encryption Successful update of database keystore entry Database Encryption
11109 _sys.ks.ke.delete.pass Encryption Successful delete of database keystore entry Database Encryption
11110 _sys.ks.ke.read.pass Encryption Successful read of database keystore entry Database Encryption
11111 _sys.ks.open.fail Encryption Failure in database keystore open Database Encryption
11112 _sys.ks.ke.create.fail Encryption Failure in database keystore entry create Database Encryption
11113 _sys.ks.ke.update.fail Encryption Failure in database keystore entry update Database Encryption
11114 _sys.ks.ke.delete.fail Encryption Failure in database keystore 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
117001 _sys.db.mt.enable Multi-tenancy Enable multi-tenant database feature with pass/fail info PSC-Multi-tenancy
117011 _sys.db.mt.disable Multi-tenancy Disable multi-tenant database feature with pass/fail info PSC-Multi-tenancy
117101 _sys.db.tenant.create Multi-tenancy Create tenant in multi-tenant database PSC-Multi-tenancy
117111 _sys.db.tenant.update Multi-tenancy Update tenant in multi-tenant database PSC-Multi-tenancy
117121 _sys.db.tenant.delete Multi-tenancy Delete tenant in multi-tenant database PSC-Multi-tenancy
117131 _sys.db.group.create Multi-tenancy Create group in multi-tenant database PSC-Multi-tenancy
117141 _sys.db.group.update Multi-tenancy Update group in multi-tenant database PSC-Multi-tenancy
117151 _sys.db.group.delete Multi-tenancy Delete group in multi-tenant database PSC-Multi-tenancy
117171 _sys.db.groupmember.create Multi-tenancy Create group member in multi-tenant database PSC-Multi-tenancy
117181 _sys.db.groupmember.update Multi-tenancy Update group member in multi-tenant database PSC-Multi-tenancy
117191 _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 for multi-tenant objects and table partitioning details for partitioned objects. For more information, see Audit data event context.