Previous      Contents      Index      Next
Sun Java[tm] System Identity Manager 6.0 Audit Logging 2005Q4M3

2

Audit Log Database Schema

The tables provided in this chapter list the audit data schema values for the following database types:

Oracle
DB2
MySQL
Sybase

---

Oracle

The following table provides a list of data schema values for the Oracle database type:

Database Column	Value
id	VARCHAR(50)  NOT NULL
name	VARCHAR(128) NOT NULL
resourceName	VARCHAR(128)
accountName	VARCHAR(50)
objectType	CHAR(2)
objectName	VARCHAR(128)
action	CHAR(2)
actionDate	CHAR(8)
actionTime	CHAR(12)
acctAttrChanges	VARCHAR(4000)
acctAttr01label	VARCHAR(50)
acctAttr01value	VARCHAR(128)
acctAttr02label	VARCHAR(50)
acctAttr02value	VARCHAR(128)
acctAttr03label	VARCHAR(50)
acctAttr03value	VARCHAR(128)
acctAttr04label	VARCHAR(50)
acctAttr04value	VARCHAR(128)
acctAttr05label	VARCHAR(50)
acctAttr05value	VARCHAR(128)
parm01label	VARCHAR(50)
parm01value	VARCHAR(128)
parm02label	VARCHAR(50)
parm02value	VARCHAR(128)
parm03label	VARCHAR(50)
parm03value	VARCHAR(128)
parm04label	VARCHAR(50)
parm04value	VARCHAR(128)
parm05label	VARCHAR(50)
parm05value	VARCHAR(128)

---

DB2

The following table provides a list of data schema values for the DB2 database type:

Database Column	Value
id	VARCHAR(50)  NOT NULL
name	VARCHAR(128) NOT NULL
resourceName	VARCHAR(128)
accountName	VARCHAR(50)
objectType	CHAR(2)
objectName	VARCHAR(128)
action	CHAR(2)
actionDate	CHAR(8)
actionTime	CHAR(12)
actionStatus	CHAR(1)
interface	VARCHAR(50)
server	VARCHAR(128)
subject	VARCHAR(128)
reason	CHAR(2)
message	VARCHAR(255)
acctAttrChanges	CLOB(16M)
acctAttr01label	VARCHAR(50)
acctAttr01value	VARCHAR(128)
acctAttr02label	VARCHAR(50)
acctAttr02value	VARCHAR(128)
acctAttr03label	VARCHAR(50)
acctAttr03value	VARCHAR(128)
acctAttr04label	VARCHAR(50)
acctAttr04value	VARCHAR(128)
acctAttr05label	VARCHAR(50)
acctAttr05value	VARCHAR(128)
parm01label	VARCHAR(50)
parm01value	VARCHAR(128)
parm02label	VARCHAR(50)
parm02value	VARCHAR(128)
parm03label	VARCHAR(50)
parm03value	VARCHAR(128)
parm04label	VARCHAR(50)
parm04value	VARCHAR(128)
parm05label	VARCHAR(50)
parm05value	VARCHAR(128)

---

MySQL

The following table provides a list of data schema values for the MySQL database type:

Database Column	Value
id	VARCHAR(50) BINARY NOT NULL
name	VARCHAR(128) BINARY NOT NULL
resourceName	VARCHAR(128)
accountName	VARCHAR(50)
objectType	CHAR(2)
objectName	VARCHAR(128)
action	CHAR(2)
actionDate	CHAR(8)
actionTime	CHAR(12)
actionStatus	CHAR(1)
interface	VARCHAR(50)
server	VARCHAR(128)
subject	VARCHAR(128)
reason	CHAR(2)
message	VARCHAR(255)
acctAttrChanges	BLOB
acctAttr01label	VARCHAR(50)
acctAttr01value	VARCHAR(128)
acctAttr02label	VARCHAR(50)
acctAttr02value	VARCHAR(128)
acctAttr03label	VARCHAR(50)
acctAttr03value	VARCHAR(128)
acctAttr04label	VARCHAR(50)
acctAttr04value	VARCHAR(128)
acctAttr05label	VARCHAR(50)
acctAttr05value	VARCHAR(128)
parm01label	VARCHAR(50)
parm01value	VARCHAR(128)
parm02label	VARCHAR(50)
parm02value	VARCHAR(128)
parm03label	VARCHAR(50)
parm03value	VARCHAR(128)
parm04label	VARCHAR(50)
parm04value	VARCHAR(128)
parm05label	VARCHAR(50)
parm05value	VARCHAR(128)

---

Sybase

The following table provides a list of data schema values for the Sybase database type:

Database Column	Value
id	VARCHAR(50) NOT NULL
name	VARCHAR(128) NOT NULL
resourceName	VARCHAR(128)
accountName	VARCHAR(50)
objectType	CHAR(2)
objectName	VARCHAR(128)
action	CHAR(2)
actionDate	CHAR(8)
actionTime	CHAR(12)
actionStatus	CHAR(1)
interface	VARCHAR(50)
server	VARCHAR(128)
subject	VARCHAR(128)
reason	CHAR(2)
message	VARCHAR(255)
acctAttrChanges	TEXT
acctAttr01label	VARCHAR(50)
acctAttr01value	VARCHAR(128)
acctAttr02label	VARCHAR(50)
acctAttr02value	VARCHAR(128)
acctAttr03label	VARCHAR(50)
acctAttr03value	VARCHAR(128)
acctAttr04label	VARCHAR(50)
acctAttr04value	VARCHAR(128)
acctAttr05label	VARCHAR(50)
acctAttr05value	VARCHAR(128)
parm01label	VARCHAR(50)
parm01value	VARCHAR(128)
parm02label	VARCHAR(50)
parm02value	VARCHAR(128)
parm03label	VARCHAR(50)
parm03value	VARCHAR(128)
parm04label	VARCHAR(50)
parm04value	VARCHAR(128)
parm05label	VARCHAR(50)
parm05value	VARCHAR(128)

---

Audit Log Database Mappings

The following tables contain the mappings between stored audit log database keys and the display string to which they map in the audit report output. Identity Manager stores items that are used as constants as short database keys to save space in the repository. The product interface does not display these mappings. Instead, you see them only when examining the output of a dump of the audit report results.

The three tables supplied in this section list:

Object key types
Action keys
Action status keys

Audit Object Type	DB Key
Administrator	AD
Admin Group	AG
Application	AP
Audit Config	AC
Audit Log	AL
Email Template	ET
Lighthouse Account	LA
Login Config	LC
Notify	NT
Object Group	OG
Policy	PO
Remedy Config	RC
Resource Account	RA
Resource	RS
Resource Object	RE
Role	RL
Role Attribute	RT
Task Definition	TD
Task Instance	TI
Task Schedule	TS
User	US
Workflow Case	WC
Workflow Process	WP
Workflow Task	WT

Action	DBKey
Approve	AP
Change Password	CP
Change Resource Password	CR
Configure	CG
Connect	CN
Create	CT
Credentials Expired	CE
Delete	DL
Delete Account	DA
Deprovision	DP
Disable	DS
Disconnect	DC
Enable	EN
Launch	LN
Load	LD
Login	LG
Logout	LO
Native Change	NC
Protect Resource Password	PT
Provision	PV
Reject	RJ
Reprovision	RV
Reset Password	RP
Terminate	TR
Update	MO
View	VW

Action Status	DB Key
Failure	F
Success	S

Previous      Contents      Next

---

Copyright 2006 Sun Microsystems, Inc. All rights reserved.