Nonstop Database, HiRDB Version 9 System Operation Guide
Examples of audit trail collection are shown below.
Table search contents (SQL specification) | Audit trail contents | |||||
---|---|---|---|---|---|---|
Executor | Privilege used | Manipulated object | Manipulated object's name | Action | ||
A user (USR1) issues the following SELECT statement: SELECT C1 FROM USR1.T1 |
Privilege | USR1 | Table access (SELECT privilege) | Table | USR1.T1 | Accesses a table (SELECT) |
Termination | USR1 | -- | Table | USR1.T1 | Accesses a table (SELECT) | |
A user (USR2) issues the following SELECT statement: SELECT T1.C1,T2.C1 FROM USR1.T1 T1,USR2.T2 T2 WHERE T1.C1=T2.C1 |
Privilege | USR2 | Table access (SELECT privilege) | Table | USR1.T1 | Accesses a table (SELECT) |
USR2 | Table access (SELECT privilege) | Table | USR2.T2 | Accesses a table (SELECT) | ||
Termination | USR2 | -- | Table | USR1.T1 | Accesses a table (SELECT) | |
USR2 | -- | Table | USR2.T2 | Accesses a table (SELECT) |
Table search contents (SQL specification) | Audit trail contents | |||||
---|---|---|---|---|---|---|
Executor | Privilege used | Manipulated object | Manipulated object's name | Action | ||
A user (USR1) issues the following CREATE TABLE statement: CREATE TABLE T1(C1 INT) IN RDAREA1 |
Privilege | USR1 | RDAREA usage privilege | RDAREA | RDAREA1 | Creates a definition |
USR1 | Owner | Schema | USR1 | Creates a definition | ||
USR1 | Owner | Table | USR1.T1 | Creates a definition | ||
Termination | USR1 | -- | Table | USR1.T1 | Creates a definition | |
A user (USR2) issues the following DROP TABLE statement: DROP TABLE T1 |
Privilege | USR2 | Owner | Table | USR2.T1 | Deletes a definition |
Termination | USR2 | -- | Table | USR2.T1 | Deletes a definition |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.