How to parse OBJ_PRIVILEGE column of DBA_AUDIT_TRAIL in 19?

From: Rich J <rich242j_at_gmail.com>
Date: Wed, 10 Jun 2020 08:04:42 -0500
Message-ID: <CAANsBX3RgMyyP9Ry2ms2CVS6tY+kv7qU5b4k=_CDrx_b=Jv3Ow_at_mail.gmail.com>



Hey all,

Looking through DBA_AUDIT_TRAIL of a 19.6 database on OL7.7, I'm trying to decode the OBJ_PRIVILEGE column on rows with GRANT OBJECT in the ACTION_NAME column. The official doc on the view:

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_AUDIT_STATEMENT.html

...doesn't say what the column is. AskTom said in v9.2 that it mirrors the SES_ACTIONS column:

https://asktom.oracle.com/pls/asktom/asktom.search?tag=how-to-track-logon-logout#45725388888922

And that's what the v19 doc also says, but the OBJ_PRIVILEGE column is now 32 characters, and I've got hits on the upper columns.

Anyone know where that documentation could be? FWIW, the docs for v20 appear to be the same as the v19 ones for this.

Thanks,
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 10 2020 - 15:04:42 CEST

Original text of this message