Hitachi

Hitachi Advanced Database Setup and Operation Guide

12.9.3 Audit trail output triggers and output items

This section explains the circumstances in which audit trails are output, and the items output in each audit trail.

The following table lists the output triggers and output items for audit trails. Because the Column structure of table function derived table for audit trail column has a large number of sub-columns, these are split across five tables.

For details about the contents of the Audit event column in each of these five tables, see Table 12‒9: List of audit target events and output items in 12.9.1 List of audit target events and output items.

For details about the contents of the Column structure of table function derived table for audit trail column in each of these five tables, see Table 12‒10: Column structure of table function derived table when retrieving audit trails in 12.9.2 Column structure of table function derived table when retrieving audit trails.

The legend and annotations for all five tables are provided after Table 12‒25: Audit trail output triggers and output items (5 of 5).

Table 12‒21: Audit trail output triggers and output items (1 of 5)

Audit event

Column structure of table function derived table for audit trail (1 of 5)

No.

Event category

Event type

Event Description

HADB version

(HADB_VERSION)

Audit trail type

(AUDIT_TRAIL_TYPE)

Event execution time

(EXEC_TIME)

Event execution user

(USER_NAME)

Event type

(EVENT_TYPE)

Event subtype

(EVENT_SUBTYPE)

1

Mandatory audit event

System event

Starting the HADB server (adbstart command)

Y

EVENT

Y

  

SYSTEM

ADBSTART

2

Stopping the HADB server (adbstop command)

Normal termination

Y

EVENT

Y

  

SYSTEM

ADBSTOP

3

Changing the HADB server operation mode (adbchgsrvmode command)

Normal termination

Y

EVENT

Y

  

SYSTEM

ADBCHGSRVMODE

4

Changing the node type (adbchgnodetype command)

Normal termination

Y

EVENT

Y

  

SYSTEM

ADBCHGNODETYPE

5

Starting and stopping output of SQL trace information (adbchgsqltrc command)

Normal termination

Y

EVENT

Y

  

SYSTEM

ADBCHGSQLTRC

6

Centrally managing client definitions (adbclientdefmang command with --update option specified)

Normal termination#2

Y

EVENT

Y

Y

SYSTEM

ADBCLIENTDEFMANG

7

Centrally managing client definitions (adbclientdefmang command with -i option specified)

Normal termination#2

Y

EVENT

Y

Y

SYSTEM

ADBCLIENTDEFMANG

8

Adding and modifying DB areas (adbmodarea command)

Normal termination#2

Y

EVENT

Y

  

SYSTEM

ADBMODAREA

9

Changing a buffer (adbmodbuff command)

Normal termination#2

Y

EVENT

Y

  

SYSTEM

ADBMODBUFF

10

Managing the updated-row columnizing facility (adbcolumnize command)

Normal termination

Y

EVENT

Y

  

SYSTEM

ADBCOLUMNIZE

11

Audit event

Granting audit admin privilege (GRANT statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

EVENT

Y

Y

AUDIT

GRANT

12

Granting audit viewer privilege (GRANT statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

EVENT

Y

Y

AUDIT

GRANT

13

Revoking audit admin privilege (REVOKE statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

EVENT

Y

Y

AUDIT

REVOKE

14

Revoking audit viewer privilege (REVOKE statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

EVENT

Y

Y

AUDIT

REVOKE

15

Defining audit targets (CREATE AUDIT statement)

Normal termination

Y

EVENT

Y

Y

AUDIT

CREATE AUDIT

16

Deleting audit target definition information (DROP AUDIT statement)

Normal termination

Y

EVENT

Y

Y

AUDIT

DROP AUDIT

17

Changing auditor passwords (ALTER USER statement)

Normal termination

Y

EVENT

Y

Y

AUDIT

ALTER USER

18

Enabling the audit trail facility (adbaudittrail command with --start option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBAUDITTRAIL START

19

Disabling the audit trail facility (adbaudittrail command with --stop option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBAUDITTRAIL STOP

20

Swapping the audit trail file (adbaudittrail command with --swap option specified)

Normal termination#2, #9

Y

EVENT

Y

Y

AUDIT

ADBAUDITTRAIL SWAP

21

Referencing information related to the audit trail facility (adbaudittrail command with -d option specified)

Normal termination#2, #9

Y

EVENT

Y

Y

AUDIT

ADBAUDITTRAIL DISPLAY

22

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (data manipulation SQL)

Normal termination

Y

EVENT

Y

Y

AUDIT

SELECT

23

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (data manipulation SQL)

Normal termination

Y

EVENT

Y

Y

AUDIT

SELECT

24

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (adbexport command with -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

25

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (adbexport command with -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

26

Retrieving data from SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

EVENT

Y

Y

AUDIT

SELECT

27

Retrieving data from viewed tables that depend on the SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

EVENT

Y

Y

AUDIT

SELECT

28

Retrieving data from SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

29

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

30

Retrieving data from SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

31

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

EVENT

Y

Y

AUDIT

ADBEXPORT

32

Converting audit trail files (adbconvertaudittrailfile command)

Normal termination#2, #9

Y

EVENT

Y

Y

AUDIT

ADBCONVERTAUDITTRAILFILE

33

Optional audit event

Session event

Connecting to the HADB server

Normal termination

Y

EVENT

Y

Y

SESSION

CONNECT

34

Disconnecting from the HADB server

Normal termination#1

Y

EVENT

Y

Y

SESSION

DISCONNECT

35

Privilege management event

Granting the DBA privilege (GRANT statement with DBA specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

36

Granting the CONNECT privilege (GRANT statement with CONNECT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

37

Granting the SCHEMA privilege (GRANT statement with SCHEMA specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

38

Granting the SELECT privilege (GRANT statement with SELECT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

39

Granting the INSERT privilege (GRANT statement with INSERT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

40

Granting the UPDATE privilege (GRANT statement with UPDATE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

41

Granting the DELETE privilege (GRANT statement with DELETE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

42

Granting the TRUNCATE privilege (GRANT statement with TRUNCATE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

43

Granting the REFERENCES privilege (GRANT statement with REFERENCES specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

44

Granting the IMPORT TABLE privilege (GRANT statement with IMPORT TABLE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

45

Granting the REBUILD INDEX privilege (GRANT statement with REBUILD INDEX specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

46

Granting the GET COSTINFO privilege (GRANT statement with GET COSTINFO specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

47

Granting the EXPORT TABLE privilege (GRANT statement with EXPORT TABLE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

48

Granting the MERGE CHUNK privilege (GRANT statement with MERGE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

49

Granting the CHANGE CHUNK COMMENT privilege (GRANT statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

50

Granting the CHANGE CHUNK STATUS privilege (GRANT statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

51

Granting the ARCHIVE CHUNK privilege (GRANT statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

52

Granting the UNARCHIVE CHUNK privilege (GRANT statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

GRANT

53

Revoking the DBA privilege (REVOKE statement with DBA specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

54

Revoking the CONNECT privilege (REVOKE statement with CONNECT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

55

Revoking the SCHEMA privilege (REVOKE statement with SCHEMA specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

56

Revoking the SELECT privilege (REVOKE statement with SELECT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

57

Revoking the INSERT privilege (REVOKE statement with INSERT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

58

Revoking the UPDATE privilege (REVOKE statement with UPDATE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

59

Revoking the DELETE privilege (REVOKE statement with DELETE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

60

Revoking the TRUNCATE privilege (REVOKE statement with TRUNCATE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

61

Revoking the REFERENCES privilege (REVOKE statement with REFERENCES specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

62

Revoking the IMPORT TABLE privilege (REVOKE statement with IMPORT TABLE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

63

Revoking the REBUILD INDEX privilege (REVOKE statement with REBUILD INDEX specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

64

Revoking the GET COSTINFO privilege (REVOKE statement with GET COSTINFO specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

65

Revoking the EXPORT TABLE privilege (REVOKE statement with EXPORT TABLE specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

66

Revoking the MERGE CHUNK privilege (REVOKE statement with MERGE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

67

Revoking the CHANGE CHUNK COMMENT privilege (REVOKE statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

68

Revoking the CHANGE CHUNK STATUS privilege (REVOKE statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

69

Revoking the ARCHIVE CHUNK privilege (REVOKE statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

70

Revoking the UNARCHIVE CHUNK privilege (REVOKE statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

EVENT

Y

Y

PRIVILEGE

REVOKE

71

Creating an HADB user (CREATE USER statement)

Normal termination

Y

EVENT

Y

Y

PRIVILEGE

CREATE USER

72

Deleting an HADB user (DROP USER statement)

Normal termination

Y

EVENT

Y

Y

PRIVILEGE

DROP USER

73

Changing user information for an HADB user (ALTER USER statement)

Normal termination

Y

EVENT

Y

Y

PRIVILEGE

ALTER USER

74

Definition SQL event

Defining an index (CREATE INDEX statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

CREATE INDEX

75

Defining a schema (CREATE SCHEMA statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

CREATE SCHEMA

76

Defining a base table (CREATE TABLE statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

CREATE TABLE

77

Defining a viewed table (CREATE VIEW statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

CREATE VIEW

78

Deleting an index (DROP INDEX statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

DROP INDEX

79

Deleting a schema (DROP SCHEMA statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

DROP SCHEMA

80

Deleting a base table (DROP TABLE statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

DROP TABLE

81

Deleting a viewed table (DROP VIEW statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

DROP VIEW

82

Changing the definition of a base table (ALTER TABLE statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

ALTER TABLE

83

Changing the definition of a viewed table (ALTER VIEW statement)

Normal termination

Y

EVENT

Y

Y

DEFINE

ALTER VIEW

84

Data manipulation SQL event

Retrieving data from tables (SELECT statement)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

SELECT

85

Inserting rows into tables (INSERT statement#3)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

INSERT

86

Updating table row data (UPDATE statement#3)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

UPDATE

87

Deleting table row data (DELETE statement#3)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

DELETE

88

Deleting all row data from a table (TRUNCATE TABLE statement)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

TRUNCATE TABLE

89

Deleting all row data in a chunk (PURGE CHUNK statement#3)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

PURGE CHUNK

90

SQL parsing error

Y

EVENT

Y

Y

MANIPULATE

UNKNOWN

91

Acquiring data stored in chunks (#GETDATA subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

GETDATA

92

Acquiring the number of data items stored in a chunk (#GETCOUNT subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

GETCOUNT

93

Displaying table information (#TABLES subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

TABLES

94

Displaying column information (#COLUMNS subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

COLUMNS

95

Displaying index information (#INDEXES subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

INDEXES

96

Displaying chunk information (#CHUNKS subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

CHUNKS

97

Displaying authorization identifiers (#GETUSER subcommand of adbsql command)

Normal termination

Y

EVENT

Y

Y

MANIPULATE

GETUSER

98

Command operation event

Importing data (adbimport command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBIMPORT

99

Exporting data (adbexport command without -q option specified)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBEXPORT

100

Exporting data (adbexport command with -q option specified)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBEXPORT

101

Rebuilding indexes (adbidxrebuild command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBIDXREBUILD

102

Collecting cost information (adbgetcst command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBGETCST

103

Analyzing DB status (adbdbstatus command)

Normal termination#2

Y

EVENT

Y

  

COMMAND

ADBDBSTATUS

104

Merging chunks (adbmergechunk command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBMERGECHUNK

105

Setting, changing, and deleting chunk comments (adbchgchunkcomment command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBCHGCHUNKCOMMENT

106

Changing the chunk status (adbchgchunkstatus command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBCHGCHUNKSTATUS

107

Archiving chunks (adbarchivechunk command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBARCHIVECHUNK

108

Unarchiving chunks (adbunarchivechunk command)

Normal termination#2

Y

EVENT

Y

Y

COMMAND

ADBUNARCHIVECHUNK

109

Reorganizing system tables (base tables) (adbreorgsystemdata command)

Normal termination#2

Y

EVENT

Y

  

COMMAND

ADBREORGSYSTEMDATA

110

Registering and deleting synonym dictionaries (adbsyndict command)

Normal termination#2

Y

EVENT

Y

  

COMMAND

ADBSYNDICT
Table 12‒22: Audit trail output triggers and output items (2 of 5)

Audit event

Column structure of table function derived table for audit trail (2 of 5)

No.

Event category

Event type

Event description

Event result

(EVENT_RESULT)

Confirmed privilege

(USED_PRIVILEGE)

OS account name on client side.

(OS_USER_NAME)

Application identifier

(AP_NAME)

Client IP address

(CLIENT_IP_ADDRESS)

Client port number

(CLIENT_PORT_NUMBER)

Client process name

(CLIENT_PROCESS_NAME)

Client process ID

(CLIENT_PROCESS_ID)

1

Mandatory audit event

System event

Starting the HADB server (adbstart command)

SUCCESS

  

Y

      

Y

Y

2

Stopping the HADB server (adbstop command)

Normal termination

SUCCESS

  

Y

  

F

F

Y

Y

3

Changing the HADB server operation mode (adbchgsrvmode command)

Normal termination

SUCCESS

  

Y

      

Y

Y

4

Changing the node type (adbchgnodetype command)

Normal termination

SUCCESS

  

Y

      

Y

Y

5

Starting and stopping output of SQL trace information (adbchgsqltrc command)

Normal termination

SUCCESS

  

Y

      

Y

Y

6

Centrally managing client definitions (adbclientdefmang command with --update option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

7

Centrally managing client definitions (adbclientdefmang command with -i option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

8

Adding and modifying DB areas (adbmodarea command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

9

Changing a buffer (adbmodbuff command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

10

Managing the updated-row columnizing facility (adbcolumnize command)

Normal termination

SUCCESS

  

Y

      

Y

Y

11

Audit event

Granting audit admin privilege (GRANT statement with AUDIT ADMIN specified)

Normal termination#6, #7

SUCCESS

  

Y

Y

Y

A

B

Y

12

Granting audit viewer privilege (GRANT statement with AUDIT VIEWER specified)

Normal termination#6, #7

SUCCESS

  

Y

Y

Y

A

B

Y

13

Revoking audit admin privilege (REVOKE statement with AUDIT ADMIN specified)

Normal termination#6, #7

SUCCESS

  

Y

Y

Y

A

B

Y

14

Revoking audit viewer privilege (REVOKE statement with AUDIT VIEWER specified)

Normal termination#6, #7

SUCCESS

  

Y

Y

Y

A

B

Y

15

Defining audit targets (CREATE AUDIT statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

16

Deleting audit target definition information (DROP AUDIT statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

17

Changing auditor passwords (ALTER USER statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

18

Enabling the audit trail facility (adbaudittrail command with --start option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

19

Disabling the audit trail facility (adbaudittrail command with --stop option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

20

Swapping the audit trail file (adbaudittrail command with --swap option specified)

Normal termination#2, #9

SUCCESS

  

Y

Y

F

F

Y

Y

21

Referencing information related to the audit trail facility (adbaudittrail command with -d option specified)

Normal termination#2, #9

SUCCESS

  

Y

Y

F

F

Y

Y

22

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (data manipulation SQL)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

23

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (data manipulation SQL)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

24

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (adbexport command with -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

25

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (adbexport command with -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

26

Retrieving data from SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

27

Retrieving data from viewed tables that depend on the SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

28

Retrieving data from SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

29

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

30

Retrieving data from SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

31

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

32

Converting audit trail files (adbconvertaudittrailfile command)

Normal termination#2, #9

SUCCESS

  

Y

Y

    

Y

Y

33

Optional audit event

Session event

Connecting to the HADB server

Normal termination

SUCCESS

  

Y

Y

D

E

B

Y

34

Disconnecting from the HADB server

Normal termination#1

SUCCESS

  

Y

Y

D

E

B

Y

35

Privilege management event

Granting the DBA privilege (GRANT statement with DBA specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

36

Granting the CONNECT privilege (GRANT statement with CONNECT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

37

Granting the SCHEMA privilege (GRANT statement with SCHEMA specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

38

Granting the SELECT privilege (GRANT statement with SELECT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

39

Granting the INSERT privilege (GRANT statement with INSERT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

40

Granting the UPDATE privilege (GRANT statement with UPDATE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

41

Granting the DELETE privilege (GRANT statement with DELETE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

42

Granting the TRUNCATE privilege (GRANT statement with TRUNCATE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

43

Granting the REFERENCES privilege (GRANT statement with REFERENCES specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

44

Granting the IMPORT TABLE privilege (GRANT statement with IMPORT TABLE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

45

Granting the REBUILD INDEX privilege (GRANT statement with REBUILD INDEX specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

46

Granting the GET COSTINFO privilege (GRANT statement with GET COSTINFO specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

47

Granting the EXPORT TABLE privilege (GRANT statement with EXPORT TABLE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

48

Granting the MERGE CHUNK privilege (GRANT statement with MERGE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

49

Granting the CHANGE CHUNK COMMENT privilege (GRANT statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

50

Granting the CHANGE CHUNK STATUS privilege (GRANT statement with CHANGE CHUNK STATUS specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

51

Granting the ARCHIVE CHUNK privilege (GRANT statement with ARCHIVE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

52

Granting the UNARCHIVE CHUNK privilege (GRANT statement with UNARCHIVE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

53

Revoking the DBA privilege (REVOKE statement with DBA specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

54

Revoking the CONNECT privilege (REVOKE statement with CONNECT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

55

Revoking the SCHEMA privilege (REVOKE statement with SCHEMA specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

56

Revoking the SELECT privilege (REVOKE statement with SELECT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

57

Revoking the INSERT privilege (REVOKE statement with INSERT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

58

Revoking the UPDATE privilege (REVOKE statement with UPDATE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

59

Revoking the DELETE privilege (REVOKE statement with DELETE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

60

Revoking the TRUNCATE privilege (REVOKE statement with TRUNCATE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

61

Revoking the REFERENCES privilege (REVOKE statement with REFERENCES specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

62

Revoking the IMPORT TABLE privilege (REVOKE statement with IMPORT TABLE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

63

Revoking the REBUILD INDEX privilege (REVOKE statement with REBUILD INDEX specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

64

Revoking the GET COSTINFO privilege (REVOKE statement with GET COSTINFO specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

65

Revoking the EXPORT TABLE privilege (REVOKE statement with EXPORT TABLE specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

66

Revoking the MERGE CHUNK privilege (REVOKE statement with MERGE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

67

Revoking the CHANGE CHUNK COMMENT privilege (REVOKE statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

68

Revoking the CHANGE CHUNK STATUS privilege (REVOKE statement with CHANGE CHUNK STATUS specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

69

Revoking the ARCHIVE CHUNK privilege (REVOKE statement with ARCHIVE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

70

Revoking the UNARCHIVE CHUNK privilege (REVOKE statement with UNARCHIVE CHUNK specified)

Normal termination#6

SUCCESS

  

Y

Y

Y

A

B

Y

71

Creating an HADB user (CREATE USER statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

72

Deleting an HADB user (DROP USER statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

73

Changing user information for an HADB user (ALTER USER statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

74

Definition SQL event

Defining an index (CREATE INDEX statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

75

Defining a schema (CREATE SCHEMA statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

76

Defining a base table (CREATE TABLE statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

77

Defining a viewed table (CREATE VIEW statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

78

Deleting an index (DROP INDEX statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

79

Deleting a schema (DROP SCHEMA statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

80

Deleting a base table (DROP TABLE statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

81

Deleting a viewed table (DROP VIEW statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

82

Changing the definition of a base table (ALTER TABLE statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

83

Changing the definition of a viewed table (ALTER VIEW statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

84

Data manipulation SQL event

Retrieving data from tables (SELECT statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

85

Inserting rows into tables (INSERT statement#3)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

86

Updating table row data (UPDATE statement#3)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

87

Deleting table row data (DELETE statement#3)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

88

Deleting all row data from a table (TRUNCATE TABLE statement)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

89

Deleting all row data in a chunk (PURGE CHUNK statement#3)

Normal termination

SUCCESS

  

Y

Y

Y

A

B

Y

90

SQL parsing error

FAILURE

  

Y

Y

Y

A

B

Y

91

Acquiring data stored in chunks (#GETDATA subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

92

Acquiring the number of data items stored in a chunk (#GETCOUNT subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

93

Displaying table information (#TABLES subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

94

Displaying column information (#COLUMNS subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

95

Displaying index information (#INDEXES subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

96

Displaying chunk information (#CHUNKS subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

97

Displaying authorization identifiers (#GETUSER subcommand of adbsql command)

Normal termination

SUCCESS

  

Y

Y

Y

A

Y

Y

98

Command operation event

Importing data (adbimport command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

99

Exporting data (adbexport command without -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

100

Exporting data (adbexport command with -q option specified)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

101

Rebuilding indexes (adbidxrebuild command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

102

Collecting cost information (adbgetcst command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

103

Analyzing DB status (adbdbstatus command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

104

Merging chunks (adbmergechunk command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

105

Setting, changing, and deleting chunk comments (adbchgchunkcomment command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

106

Changing the chunk status (adbchgchunkstatus command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

107

Archiving chunks (adbarchivechunk command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

108

Unarchiving chunks (adbunarchivechunk command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

109

Reorganizing system tables (base tables) (adbreorgsystemdata command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y

110

Registering and deleting synonym dictionaries (adbsyndict command)

Normal termination#2

SUCCESS

  

Y

Y

    

Y

Y
Table 12‒23: Audit trail output triggers and output items (3 of 5)

Audit event

Column structure of table function derived table for audit trail (3 of 5)

No.

Event category

Event type

Event Description

HADB host name

(HADB_HOST_NAME)

HADB IP address

(HADB_IP_ADDRESS)

HADB port number

(HADB_PORT_NUMBER)

HADB process ID

(HADB_PROCESS_ID)

HADB server directory

(ADBDIR)

HADB node number#8

(HADB_NODE_NUMBER)

Connection ID

(CONNECTION_ID)

Connection sequence number

(CONNECTION_NUMBER)

Statement handle

(STATEMENT_HANDLE)

SQL statement serial number

(SQL_SERIAL_NUMBER)

1

Mandatory audit event

System event

Starting the HADB server (adbstart command)

Y

Y

Y

Y

Y

Y

        

2

Stopping the HADB server (adbstop command)

Normal termination

Y

Y

Y

Y

Y

Y

        

3

Changing the HADB server operation mode (adbchgsrvmode command)

Normal termination

Y

Y

Y

Y

Y

Y

        

4

Changing the node type (adbchgnodetype command)

Normal termination

Y

Y

Y

Y

Y

Y

        

5

Starting and stopping output of SQL trace information (adbchgsqltrc command)

Normal termination

Y

Y

Y

Y

Y

Y

        

6

Centrally managing client definitions (adbclientdefmang command with --update option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

7

Centrally managing client definitions (adbclientdefmang command with -i option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

8

Adding and modifying DB areas (adbmodarea command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

9

Changing a buffer (adbmodbuff command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

10

Managing the updated-row columnizing facility (adbcolumnize command)

Normal termination

Y

Y

Y

Y

Y

Y

        

11

Audit event

Granting audit admin privilege (GRANT statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

12

Granting audit viewer privilege (GRANT statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

13

Revoking audit admin privilege (REVOKE statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

14

Revoking audit viewer privilege (REVOKE statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

15

Defining audit targets (CREATE AUDIT statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

16

Deleting audit target definition information (DROP AUDIT statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

17

Changing auditor passwords (ALTER USER statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

18

Enabling the audit trail facility (adbaudittrail command with --start option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

19

Disabling the audit trail facility (adbaudittrail command with --stop option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

20

Swapping the audit trail file (adbaudittrail command with --swap option specified)

Normal termination#2, #9

Y

Y

Y

Y

Y

Y

Y

Y

    

21

Referencing information related to the audit trail facility (adbaudittrail command with -d option specified)

Normal termination#2, #9

Y

Y

Y

Y

Y

Y

Y

Y

    

22

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (data manipulation SQL)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

23

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (data manipulation SQL)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

24

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (adbexport command with -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

25

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (adbexport command with -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

26

Retrieving data from SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

27

Retrieving data from viewed tables that depend on the SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

28

Retrieving data from SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

29

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

30

Retrieving data from SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

31

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

32

Converting audit trail files (adbconvertaudittrailfile command)

Normal termination#2, #9

Y

Y

Y

Y

Y

Y

Y

Y

    

33

Optional audit event

Session event

Connecting to the HADB server

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

34

Disconnecting from the HADB server

Normal termination#1

Y

Y

Y

Y

Y

Y

Y

Y

    

35

Privilege management event

Granting the DBA privilege (GRANT statement with DBA specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

36

Granting the CONNECT privilege (GRANT statement with CONNECT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

37

Granting the SCHEMA privilege (GRANT statement with SCHEMA specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

38

Granting the SELECT privilege (GRANT statement with SELECT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

39

Granting the INSERT privilege (GRANT statement with INSERT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

40

Granting the UPDATE privilege (GRANT statement with UPDATE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

41

Granting the DELETE privilege (GRANT statement with DELETE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

42

Granting the TRUNCATE privilege (GRANT statement with TRUNCATE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

43

Granting the REFERENCES privilege (GRANT statement with REFERENCES specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

44

Granting the IMPORT TABLE privilege (GRANT statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

45

Granting the REBUILD INDEX privilege (GRANT statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

46

Granting the GET COSTINFO privilege (GRANT statement with GET COSTINFO specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

47

Granting the EXPORT TABLE privilege (GRANT statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

48

Granting the MERGE CHUNK privilege (GRANT statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

49

Granting the CHANGE CHUNK COMMENT privilege (GRANT statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

50

Granting the CHANGE CHUNK STATUS privilege (GRANT statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

51

Granting the ARCHIVE CHUNK privilege (GRANT statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

52

Granting the UNARCHIVE CHUNK privilege (GRANT statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

53

Revoking the DBA privilege (REVOKE statement with DBA specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

54

Revoking the CONNECT privilege (REVOKE statement with CONNECT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

55

Revoking the SCHEMA privilege (REVOKE statement with SCHEMA specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

56

Revoking the SELECT privilege (REVOKE statement with SELECT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

57

Revoking the INSERT privilege (REVOKE statement with INSERT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

58

Revoking the UPDATE privilege (REVOKE statement with UPDATE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

59

Revoking the DELETE privilege (REVOKE statement with DELETE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

60

Revoking the TRUNCATE privilege (REVOKE statement with TRUNCATE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

61

Revoking the REFERENCES privilege (REVOKE statement with REFERENCES specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

62

Revoking the IMPORT TABLE privilege (REVOKE statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

63

Revoking the REBUILD INDEX privilege (REVOKE statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

64

Revoking the GET COSTINFO privilege (REVOKE statement with GET COSTINFO specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

65

Revoking the EXPORT TABLE privilege (REVOKE statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

66

Revoking the MERGE CHUNK privilege (REVOKE statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

67

Revoking the CHANGE CHUNK COMMENT privilege (REVOKE statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

68

Revoking the CHANGE CHUNK STATUS privilege (REVOKE statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

69

Revoking the ARCHIVE CHUNK privilege (REVOKE statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

70

Revoking the UNARCHIVE CHUNK privilege (REVOKE statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

71

Creating an HADB user (CREATE USER statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

72

Deleting an HADB user (DROP USER statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

73

Changing user information for an HADB user (ALTER USER statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

74

Definition SQL event

Defining an index (CREATE INDEX statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

75

Defining a schema (CREATE SCHEMA statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

76

Defining a base table (CREATE TABLE statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

77

Defining a viewed table (CREATE VIEW statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

78

Deleting an index (DROP INDEX statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

79

Deleting a schema (DROP SCHEMA statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

80

Deleting a base table (DROP TABLE statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

81

Deleting a viewed table (DROP VIEW statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

82

Changing the definition of a base table (ALTER TABLE statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

83

Changing the definition of a viewed table (ALTER VIEW statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

84

Data manipulation SQL event

Retrieving data from tables (SELECT statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

85

Inserting rows into tables (INSERT statement#3)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

86

Updating table row data (UPDATE statement#3)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

87

Deleting table row data (DELETE statement#3)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

88

Deleting all row data from a table (TRUNCATE TABLE statement)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

89

Deleting all row data in a chunk (PURGE CHUNK statement#3)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

90

SQL parsing error

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

91

Acquiring data stored in chunks (#GETDATA subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

92

Acquiring the number of data items stored in a chunk (#GETCOUNT subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

93

Displaying table information (#TABLES subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

94

Displaying column information (#COLUMNS subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

95

Displaying index information (#INDEXES subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

96

Displaying chunk information (#CHUNKS subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

97

Displaying authorization identifiers (#GETUSER subcommand of adbsql command)

Normal termination

Y

Y

Y

Y

Y

Y

Y

Y

    

98

Command operation event

Importing data (adbimport command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

99

Exporting data (adbexport command without -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

100

Exporting data (adbexport command with -q option specified)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

101

Rebuilding indexes (adbidxrebuild command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

102

Collecting cost information (adbgetcst command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

103

Analyzing DB status (adbdbstatus command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

104

Merging chunks (adbmergechunk command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

105

Setting, changing, and deleting chunk comments (adbchgchunkcomment command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

106

Changing the chunk status (adbchgchunkstatus command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

107

Archiving chunks (adbarchivechunk command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

108

Unarchiving chunks (adbunarchivechunk command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

109

Reorganizing system tables (base tables) (adbreorgsystemdata command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    

110

Registering and deleting synonym dictionaries (adbsyndict command)

Normal termination#2

Y

Y

Y

Y

Y

Y

Y

Y

    
Table 12‒24: Audit trail output triggers and output items (4 of 5)

Audit event

Column structure of table function derived table for audit trail (4 of 5)

No.

Event category

Event type

Event Description

Message log information

(MESSAGE_LOG_INFO)

End code

(EXIT_STATUS)

Object type#4

(OBJECT_TYPE)

Object owner#4

(OBJECT_OWNER_NAME)

Object schema name#4

(OBJECT_SCHEMA_NAME)

Object name#4

(OBJECT_NAME)

Access count#5

(ACCESS_COUNT)

1

Mandatory audit event

System event

Starting the HADB server (adbstart command)

Y

Y

          

2

Stopping the HADB server (adbstop command)

Normal termination

Y

Y

          

3

Changing the HADB server operation mode (adbchgsrvmode command)

Normal termination

Y

Y

          

4

Changing the node type (adbchgnodetype command)

Normal termination

Y

Y

          

5

Starting and stopping output of SQL trace information (adbchgsqltrc command)

Normal termination

Y

Y

          

6

Centrally managing client definitions (adbclientdefmang command with --update option specified)

Normal termination#2

Y

Y

          

7

Centrally managing client definitions (adbclientdefmang command with -i option specified)

Normal termination#2

Y

Y

          

8

Adding and modifying DB areas (adbmodarea command)

Normal termination#2

Y

Y

          

9

Changing a buffer (adbmodbuff command)

Normal termination#2

Y

Y

          

10

Managing the updated-row columnizing facility (adbcolumnize command)

Normal termination

Y

Y

          

11

Audit event

Granting audit admin privilege (GRANT statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

        

Y

12

Granting audit viewer privilege (GRANT statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

        

Y

13

Revoking audit admin privilege (REVOKE statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

        

Y

14

Revoking audit viewer privilege (REVOKE statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

        

Y

15

Defining audit targets (CREATE AUDIT statement)

Normal termination

Y

Y

        

Y

16

Deleting audit target definition information (DROP AUDIT statement)

Normal termination

Y

Y

        

Y

17

Changing auditor passwords (ALTER USER statement)

Normal termination

Y

Y

        

Y

18

Enabling the audit trail facility (adbaudittrail command with --start option specified)

Normal termination#2

Y

Y

          

19

Disabling the audit trail facility (adbaudittrail command with --stop option specified)

Normal termination#2

Y

Y

          

20

Swapping the audit trail file (adbaudittrail command with --swap option specified)

Normal termination#2, #9

Y

Y

          

21

Referencing information related to the audit trail facility (adbaudittrail command with -d option specified)

Normal termination#2, #9

Y

Y

          

22

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (data manipulation SQL)

Normal termination

Y

Y

TABLE FUNCTION

Y

Y

Y

Y

23

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (data manipulation SQL)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

24

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (adbexport command with -q option specified)

Normal termination#2

Y

Y

TABLE FUNCTION

Y

Y

Y

Y

25

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (adbexport command with -q option specified)

Normal termination#2

Y

Y

VIEW

Y

Y

Y

Y

26

Retrieving data from SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

27

Retrieving data from viewed tables that depend on the SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

28

Retrieving data from SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

Y

VIEW

Y

Y

Y

Y

29

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

Y

Y

VIEW

Y

Y

Y

Y

30

Retrieving data from SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

Y

VIEW

Y

Y

Y

Y

31

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

Y

Y

VIEW

Y

Y

Y

Y

32

Converting audit trail files (adbconvertaudittrailfile command)

Normal termination#2, #9

Y

Y

          

33

Optional audit event

Session event

Connecting to the HADB server

Normal termination

Y

Y

          

34

Disconnecting from the HADB server

Normal termination#1

Y

Y

          

35

Privilege management event

Granting the DBA privilege (GRANT statement with DBA specified)

Normal termination#6

Y

Y

        

Y

36

Granting the CONNECT privilege (GRANT statement with CONNECT specified)

Normal termination#6

Y

Y

        

Y

37

Granting the SCHEMA privilege (GRANT statement with SCHEMA specified)

Normal termination#6

Y

Y

        

Y

38

Granting the SELECT privilege (GRANT statement with SELECT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

39

Granting the INSERT privilege (GRANT statement with INSERT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

40

Granting the UPDATE privilege (GRANT statement with UPDATE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

41

Granting the DELETE privilege (GRANT statement with DELETE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

42

Granting the TRUNCATE privilege (GRANT statement with TRUNCATE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

43

Granting the REFERENCES privilege (GRANT statement with REFERENCES specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

44

Granting the IMPORT TABLE privilege (GRANT statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

45

Granting the REBUILD INDEX privilege (GRANT statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

46

Granting the GET COSTINFO privilege (GRANT statement with GET COSTINFO specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

47

Granting the EXPORT TABLE privilege (GRANT statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

48

Granting the MERGE CHUNK privilege (GRANT statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

49

Granting the CHANGE CHUNK COMMENT privilege (GRANT statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

50

Granting the CHANGE CHUNK STATUS privilege (GRANT statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

51

Granting the ARCHIVE CHUNK privilege (GRANT statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

52

Granting the UNARCHIVE CHUNK privilege (GRANT statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

53

Revoking the DBA privilege (REVOKE statement with DBA specified)

Normal termination#6

Y

Y

        

Y

54

Revoking the CONNECT privilege (REVOKE statement with CONNECT specified)

Normal termination#6

Y

Y

        

Y

55

Revoking the SCHEMA privilege (REVOKE statement with SCHEMA specified)

Normal termination#6

Y

Y

        

Y

56

Revoking the SELECT privilege (REVOKE statement with SELECT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

57

Revoking the INSERT privilege (REVOKE statement with INSERT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

58

Revoking the UPDATE privilege (REVOKE statement with UPDATE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

59

Revoking the DELETE privilege (REVOKE statement with DELETE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

60

Revoking the TRUNCATE privilege (REVOKE statement with TRUNCATE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

61

Revoking the REFERENCES privilege (REVOKE statement with REFERENCES specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

62

Revoking the IMPORT TABLE privilege (REVOKE statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

63

Revoking the REBUILD INDEX privilege (REVOKE statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

64

Revoking the GET COSTINFO privilege (REVOKE statement with GET COSTINFO specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

65

Revoking the EXPORT TABLE privilege (REVOKE statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

66

Revoking the MERGE CHUNK privilege (REVOKE statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

67

Revoking the CHANGE CHUNK COMMENT privilege (REVOKE statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

68

Revoking the CHANGE CHUNK STATUS privilege (REVOKE statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

69

Revoking the ARCHIVE CHUNK privilege (REVOKE statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

70

Revoking the UNARCHIVE CHUNK privilege (REVOKE statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

TABLE or VIEW

Y

Y

Y

Y

71

Creating an HADB user (CREATE USER statement)

Normal termination

Y

Y

        

Y

72

Deleting an HADB user (DROP USER statement)

Normal termination

Y

Y

        

Y

73

Changing user information for an HADB user (ALTER USER statement)

Normal termination

Y

Y

        

Y

74

Definition SQL event

Defining an index (CREATE INDEX statement)

Normal termination

Y

Y

INDEX

Y

Y

Y

Y

75

Defining a schema (CREATE SCHEMA statement)

Normal termination

Y

Y

SCHEMA

Y

  

Y

Y

76

Defining a base table (CREATE TABLE statement)

Normal termination

Y

Y

TABLE

Y

Y

Y

Y

77

Defining a viewed table (CREATE VIEW statement)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

78

Deleting an index (DROP INDEX statement)

Normal termination

Y

Y

INDEX

Y

Y

Y

Y

79

Deleting a schema (DROP SCHEMA statement)

Normal termination

Y

Y

SCHEMA

Y

  

Y

Y

80

Deleting a base table (DROP TABLE statement)

Normal termination

Y

Y

TABLE

Y

Y

Y

Y

81

Deleting a viewed table (DROP VIEW statement)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

82

Changing the definition of a base table (ALTER TABLE statement)

Normal termination

Y

Y

TABLE

Y

Y

Y

Y

83

Changing the definition of a viewed table (ALTER VIEW statement)

Normal termination

Y

Y

VIEW

Y

Y

Y

Y

84

Data manipulation SQL event

Retrieving data from tables (SELECT statement)

Normal termination

Y

Y

TABLE, VIEW, or TABLE FUNCTION

Y

Y

Y

Y

85

Inserting rows into tables (INSERT statement#3)

Normal termination

Y

Y

TABLE or VIEW

Y

Y

Y

Y

86

Updating table row data (UPDATE statement#3)

Normal termination

Y

Y

TABLE or VIEW

Y

Y

Y

Y

87

Deleting table row data (DELETE statement#3)

Normal termination

Y

Y

TABLE or VIEW

Y

Y

Y

Y

88

Deleting all row data from a table (TRUNCATE TABLE statement)

Normal termination

Y

Y

TABLE

Y

Y

Y

Y

89

Deleting all row data in a chunk (PURGE CHUNK statement#3)

Normal termination

Y

Y

TABLE

Y

Y

Y

Y

90

SQL parsing error

Y

Y

        

Y

91

Acquiring data stored in chunks (#GETDATA subcommand of adbsql command)

Normal termination

Y

Y

        

Y

92

Acquiring the number of data items stored in a chunk (#GETCOUNT subcommand of adbsql command)

Normal termination

Y

Y

        

Y

93

Displaying table information (#TABLES subcommand of adbsql command)

Normal termination

Y

Y

        

Y

94

Displaying column information (#COLUMNS subcommand of adbsql command)

Normal termination

Y

Y

        

Y

95

Displaying index information (#INDEXES subcommand of adbsql command)

Normal termination

Y

Y

        

Y

96

Displaying chunk information (#CHUNKS subcommand of adbsql command)

Normal termination

Y

Y

        

Y

97

Displaying authorization identifiers (#GETUSER subcommand of adbsql command)

Normal termination

Y

Y

        

Y

98

Command operation event

Importing data (adbimport command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

Y

99

Exporting data (adbexport command without -q option specified)

Normal termination#2

Y

Y

TABLE or VIEW

Y

Y

Y

Y

100

Exporting data (adbexport command with -q option specified)

Normal termination#2

Y

Y

TABLE, VIEW, or TABLE FUNCTION

Y

Y

Y

Y

101

Rebuilding indexes (adbidxrebuild command)

Normal termination#2

Y

Y

INDEX

Y

Y

Y

  

102

Collecting cost information (adbgetcst command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

103

Analyzing DB status (adbdbstatus command)

Normal termination#2

Y

Y

          

104

Merging chunks (adbmergechunk command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

105

Setting, changing, and deleting chunk comments (adbchgchunkcomment command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

106

Changing the chunk status (adbchgchunkstatus command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

107

Archiving chunks (adbarchivechunk command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

108

Unarchiving chunks (adbunarchivechunk command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

109

Reorganizing system tables (base tables) (adbreorgsystemdata command)

Normal termination#2

Y

Y

TABLE

Y

Y

Y

  

110

Registering and deleting synonym dictionaries (adbsyndict command)

Normal termination#2

Y

Y

          
Table 12‒25: Audit trail output triggers and output items (5 of 5)

Audit event

Column structure of table function derived table for audit trail (5 of 5)

No.

Event category

Event type

Event Description

Privilege that was granted or revoked

(PRIVILEGE_TYPE)

Authorization identifier targeted by the event

(PRIVILEGE_USER_NAME)

SQL statement

(SQL_SOURCE)

Dynamic parameters

(PARAM)

System change information (from before change)

(BEFORE_SYSTEM_INFO)

System change information (from after change)

(AFTER_SYSTEM_INFO)

Database configuration information

(SERVER_OPERAND)

Additional user information 1

(USER_INFO_1)

Additional user information 2

(USER_INFO_2)

Additional user information 3

(USER_INFO_3)

1

Mandatory audit event

System event

Starting the HADB server (adbstart command)

        

C

Y

Y

      

2

Stopping the HADB server (adbstop command)

Normal termination

                    

3

Changing the HADB server operation mode (adbchgsrvmode command)

Normal termination

        

Y

Y

        

4

Changing the node type (adbchgnodetype command)

Normal termination

        

Y

Y

        

5

Starting and stopping output of SQL trace information (adbchgsqltrc command)

Normal termination

        

Y

Y

        

6

Centrally managing client definitions (adbclientdefmang command with --update option specified)

Normal termination#2

        

Y

Y

        

7

Centrally managing client definitions (adbclientdefmang command with -i option specified)

Normal termination#2

                    

8

Adding and modifying DB areas (adbmodarea command)

Normal termination#2

        

Y

Y

        

9

Changing a buffer (adbmodbuff command)

Normal termination#2

        

Y

Y

        

10

Managing the updated-row columnizing facility (adbcolumnize command)

Normal termination

        

Y

Y

        

11

Audit event

Granting audit admin privilege (GRANT statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

Y

        

Y

Y

Y

12

Granting audit viewer privilege (GRANT statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

Y

        

Y

Y

Y

13

Revoking audit admin privilege (REVOKE statement with AUDIT ADMIN specified)

Normal termination#6, #7

Y

Y

Y

        

Y

Y

Y

14

Revoking audit viewer privilege (REVOKE statement with AUDIT VIEWER specified)

Normal termination#6, #7

Y

Y

Y

        

Y

Y

Y

15

Defining audit targets (CREATE AUDIT statement)

Normal termination

    

Y

        

Y

Y

Y

16

Deleting audit target definition information (DROP AUDIT statement)

Normal termination

    

Y

        

Y

Y

Y

17

Changing auditor passwords (ALTER USER statement)

Normal termination

  

Y

Y

        

Y

Y

Y

18

Enabling the audit trail facility (adbaudittrail command with --start option specified)

Normal termination#2

                    

19

Disabling the audit trail facility (adbaudittrail command with --stop option specified)

Normal termination#2

                    

20

Swapping the audit trail file (adbaudittrail command with --swap option specified)

Normal termination#2, #9

                    

21

Referencing information related to the audit trail facility (adbaudittrail command with -d option specified)

Normal termination#2, #9

                    

22

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (data manipulation SQL)

Normal termination

    

Y

Y

      

Y

Y

Y

23

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (data manipulation SQL)

Normal termination

    

Y

Y

      

Y

Y

Y

24

Executing a system-defined function for audit trails (ADB_AUDITREAD function) (adbexport command with -q option specified)

Normal termination#2

    

Y

              

25

Retrieving data from a viewed table that depends on a derived table that specifies an ADB_AUDITREAD function (adbexport command with -q option specified)

Normal termination#2

    

Y

              

26

Retrieving data from SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

    

Y

Y

      

Y

Y

Y

27

Retrieving data from viewed tables that depend on the SQL_AUDITS dictionary table (data manipulation SQL)

Normal termination

    

Y

Y

      

Y

Y

Y

28

Retrieving data from SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

                    

29

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command without -q option specified)

Normal termination#2

                    

30

Retrieving data from SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

    

Y

              

31

Retrieving data from viewed table that depends on SQL_AUDITS dictionary table (adbexport command with -q option specified)

Normal termination#2

    

Y

              

32

Converting audit trail files (adbconvertaudittrailfile command)

Normal termination#2, #9

                    

33

Optional audit event

Session event

Connecting to the HADB server

Normal termination

                    

34

Disconnecting from the HADB server

Normal termination#1

              

Y

Y

Y

35

Privilege management event

Granting the DBA privilege (GRANT statement with DBA specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

36

Granting the CONNECT privilege (GRANT statement with CONNECT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

37

Granting the SCHEMA privilege (GRANT statement with SCHEMA specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

38

Granting the SELECT privilege (GRANT statement with SELECT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

39

Granting the INSERT privilege (GRANT statement with INSERT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

40

Granting the UPDATE privilege (GRANT statement with UPDATE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

41

Granting the DELETE privilege (GRANT statement with DELETE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

42

Granting the TRUNCATE privilege (GRANT statement with TRUNCATE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

43

Granting the REFERENCES privilege (GRANT statement with REFERENCES specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

44

Granting the IMPORT TABLE privilege (GRANT statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

45

Granting the REBUILD INDEX privilege (GRANT statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

46

Granting the GET COSTINFO privilege (GRANT statement with GET COSTINFO specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

47

Granting the EXPORT TABLE privilege (GRANT statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

48

Granting the MERGE CHUNK privilege (GRANT statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

49

Granting the CHANGE CHUNK COMMENT privilege (GRANT statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

50

Granting the CHANGE CHUNK STATUS privilege (GRANT statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

51

Granting the ARCHIVE CHUNK privilege (GRANT statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

52

Granting the UNARCHIVE CHUNK privilege (GRANT statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

53

Revoking the DBA privilege (REVOKE statement with DBA specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

54

Revoking the CONNECT privilege (REVOKE statement with CONNECT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

55

Revoking the SCHEMA privilege (REVOKE statement with SCHEMA specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

56

Revoking the SELECT privilege (REVOKE statement with SELECT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

57

Revoking the INSERT privilege (REVOKE statement with INSERT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

58

Revoking the UPDATE privilege (REVOKE statement with UPDATE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

59

Revoking the DELETE privilege (REVOKE statement with DELETE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

60

Revoking the TRUNCATE privilege (REVOKE statement with TRUNCATE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

61

Revoking the REFERENCES privilege (REVOKE statement with REFERENCES specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

62

Revoking the IMPORT TABLE privilege (REVOKE statement with IMPORT TABLE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

63

Revoking the REBUILD INDEX privilege (REVOKE statement with REBUILD INDEX specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

64

Revoking the GET COSTINFO privilege (REVOKE statement with GET COSTINFO specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

65

Revoking the EXPORT TABLE privilege (REVOKE statement with EXPORT TABLE specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

66

Revoking the MERGE CHUNK privilege (REVOKE statement with MERGE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

67

Revoking the CHANGE CHUNK COMMENT privilege (REVOKE statement with CHANGE CHUNK COMMENT specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

68

Revoking the CHANGE CHUNK STATUS privilege (REVOKE statement with CHANGE CHUNK STATUS specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

69

Revoking the ARCHIVE CHUNK privilege (REVOKE statement with ARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

70

Revoking the UNARCHIVE CHUNK privilege (REVOKE statement with UNARCHIVE CHUNK specified)

Normal termination#6

Y

Y

Y

        

Y

Y

Y

71

Creating an HADB user (CREATE USER statement)

Normal termination

  

Y

Y

        

Y

Y

Y

72

Deleting an HADB user (DROP USER statement)

Normal termination

  

Y

Y

        

Y

Y

Y

73

Changing user information for an HADB user (ALTER USER statement)

Normal termination

  

Y

Y

        

Y

Y

Y

74

Definition SQL event

Defining an index (CREATE INDEX statement)

Normal termination

    

Y

        

Y

Y

Y

75

Defining a schema (CREATE SCHEMA statement)

Normal termination

    

Y

        

Y

Y

Y

76

Defining a base table (CREATE TABLE statement)

Normal termination

    

Y

        

Y

Y

Y

77

Defining a viewed table (CREATE VIEW statement)

Normal termination

    

Y

        

Y

Y

Y

78

Deleting an index (DROP INDEX statement)

Normal termination

    

Y

        

Y

Y

Y

79

Deleting a schema (DROP SCHEMA statement)

Normal termination

    

Y

        

Y

Y

Y

80

Deleting a base table (DROP TABLE statement)

Normal termination

    

Y

        

Y

Y

Y

81

Deleting a viewed table (DROP VIEW statement)

Normal termination

    

Y

        

Y

Y

Y

82

Changing the definition of a base table (ALTER TABLE statement)

Normal termination

    

Y

        

Y

Y

Y

83

Changing the definition of a viewed table (ALTER VIEW statement)

Normal termination

    

Y

        

Y

Y

Y

84

Data manipulation SQL event

Retrieving data from tables (SELECT statement)

Normal termination

    

Y

Y

      

Y

Y

Y

85

Inserting rows into tables (INSERT statement#3)

Normal termination

    

Y

Y

      

Y

Y

Y

86

Updating table row data (UPDATE statement#3)

Normal termination

    

Y

Y

      

Y

Y

Y

87

Deleting table row data (DELETE statement#3)

Normal termination

    

Y

Y

      

Y

Y

Y

88

Deleting all row data from a table (TRUNCATE TABLE statement)

Normal termination

    

Y

        

Y

Y

Y

89

Deleting all row data in a chunk (PURGE CHUNK statement#3)

Normal termination

    

Y

Y

      

Y

Y

Y

90

SQL parsing error

    

Y

        

Y

Y

Y

91

Acquiring data stored in chunks (#GETDATA subcommand of adbsql command)

Normal termination

                    

92

Acquiring the number of data items stored in a chunk (#GETCOUNT subcommand of adbsql command)

Normal termination

                    

93

Displaying table information (#TABLES subcommand of adbsql command)

Normal termination

                    

94

Displaying column information (#COLUMNS subcommand of adbsql command)

Normal termination

                    

95

Displaying index information (#INDEXES subcommand of adbsql command)

Normal termination

                    

96

Displaying chunk information (#CHUNKS subcommand of adbsql command)

Normal termination

                    

97

Displaying authorization identifiers (#GETUSER subcommand of adbsql command)

Normal termination

                    

98

Command operation event

Importing data (adbimport command)

Normal termination#2

                    

99

Exporting data (adbexport command without -q option specified)

Normal termination#2

                    

100

Exporting data (adbexport command with -q option specified)

Normal termination#2

    

Y

              

101

Rebuilding indexes (adbidxrebuild command)

Normal termination#2

                    

102

Collecting cost information (adbgetcst command)

Normal termination#2

                    

103

Analyzing DB status (adbdbstatus command)

Normal termination#2

                    

104

Merging chunks (adbmergechunk command)

Normal termination#2

                    

105

Setting, changing, and deleting chunk comments (adbchgchunkcomment command)

Normal termination#2

                    

106

Changing the chunk status (adbchgchunkstatus command)

Normal termination#2

                    

107

Archiving chunks (adbarchivechunk command)

Normal termination#2

                    

108

Unarchiving chunks (adbunarchivechunk command)

Normal termination#2

                    

109

Reorganizing system tables (base tables) (adbreorgsystemdata command)

Normal termination#2

                    

110

Registering and deleting synonym dictionaries (adbsyndict command)

Normal termination#2

                    

Legend:

Y

If there is output information, the applicable information is output. If there is no output information, NULL is output.

Blank

NULL is output.

A

If the connection uses UNIX domain communication, NULL is output.

B

If the client is the JDBC driver, NULL is output.

C

When using the multi-node function, different nodes will output different information.

  • For the master node, the output information is the HADB server operation mode of the node that was the master node the last time the HADB server started.

  • For the slave node, NULL is always output in this column.

D

NULL is output if this operation occurs as an additional part of command processing.

E

If either of the following applies, NULL is output:

  • The connection uses UNIX domain communication

  • The operation occurs as an additional part of command processing

F

When using the multi-node function, the IP address and port number used by the master node for inter-server communication are output for audit trails to which any of the following apply. For audit trails to which none of the following apply, NULL is output.

  • An audit trail for which ADBSTOP is output in the event subtype (EVENT_SUBTYPE) column when the adbstop command is executed on the master node without specifying the --node option

    This applies to audit trails output by the slave node.

  • An audit trail for which ADBAUDITTRAIL SWAP is output in the event subtype (EVENT_SUBTYPE) column when the adbaudittrail --swap command is executed with the node number of the slave node specified in the -n option

    This applies to audit trails whose processing was executed on the slave node and which were output by the slave node.

  • An audit trail for which ADBAUDITTRAIL DISPLAY is output in the event subtype (EVENT_SUBTYPE) column when the adbaudittrail -d command is executed with the node number of the slave node specified in the -n option

    This applies to audit trails whose processing was executed on the slave node and which were output by the slave node.

Note:

For output information (such as EVENT and SYSTEM) that does not link to an entry in the preceding legend, the information described in the table is output. For details, see Table 12‒10: Column structure of table function derived table when retrieving audit trails in 12.9.2 Column structure of table function derived table when retrieving audit trails.

Note that if there is no output information in the object type (OBJECT_TYPE) column, NULL is output.

#1

This does not include use of the close method of the Connection object when using connection pooling (it is output in the SQL trace information as the DISP call type).

#2

Before and after this event, audit trails for which CONNECT and DISCONNECT are output in the event subtype column (EVENT_SUBTYPE) are each output. For each of these audit trails, the executed command name is output in the following columns:

  • Application identifier (AP_NAME) column

  • Client process name (CLIENT_PROCESS_NAME) column

#3

The information output to audit trails differs when an SQL statement is executed that includes a query expression body in data manipulation SQL other than a SELECT statement. In this case, audit trails related to the objects described in the query expression body show the same information in this table (Retrieving data from tables (SELECT statement).

#4

If either of the following applies, NULL is output even if the table contains output information for that column:

  • The objects targeted by the event are all table value constructors

  • During command execution, processing was not executed with respect to any object

#5

NULL is output if the statement handle was closed with only the SQL preprocessing completed. This is to distinguish from situations where execution of the SQL statement has completed. This does not apply to commands.

#6

If privileges did not need to be granted to or revoked from any of the authorization identifiers specified in the SQL statement, NULL is output in the following columns:

  • Object type (OBJECT_TYPE) column

  • Object owner (OBJECT_OWNER_NAME) column

  • Object schema name (OBJECT_SCHEMA_NAME) column

  • Object name (OBJECT_NAME) column

  • Privilege that was granted or revoked (PRIVILEGE_TYPE) column

  • Authorization identifier targeted by the event (PRIVILEGE_USER_NAME) column

#7

If privileges did not need to be granted to or revoked from any of the authorization identifiers specified in the SQL statement, PRIVILEGE is output in the event type (EVENT_TYPE) column.

#8

Information is output in this column when using the multi-node function. If the multi-node function is not being used, NULL is output.

#9

If the multi-node function is being used, audit trails for which CONNECT and DISCONNECT are output in the event subtype column (EVENT_SUBTYPE) are always output on the master node.

To Page Top

All Rights Reserved. Copyright (C) 2012, 2020, Hitachi, Ltd.