...
OLD_KREW_DOC_HDR_CNTNT_T
View:
AUDIT_TRAIL
| Column Name | Length | Sample Data |
|---|---|---|
| OS_USERNAME | 255 | tomcat kfsctmuser iadmin ucdstage dsadm root btp98001 kec14023 kaa02003 |
| USERNAME | 30 | KR_PRD KFS_PRD ACH_UAT_USR_RO KFS_PRD_ETL_RO RSMART_RO KFS_PRD_FOC_RO BTP98001 KEC14023 KAA02003 |
| USERHOST | 128 | dsprod webfocusprod dsdev webfocusdev HZMW5S1 BZ1NBP1 9HDKVV1 UCONN\HZMW5S1 kfs20.uits.uconn.edu |
| TIMESTAMP | 19 | |
| OWNER | 30 | KFS_PRD KR_PRD |
| OBJ_NAME | 128 | Database Table Name |
| ACTION_NAME | 28 | UPDATE INSERT DELETE SELECT |
Query used -
select distinct USERNAME
...