I think it's interesting that even Oracle Support doesn't know the answer
to this. They keep giving me untested answers from Development, leaving me
to (dis)prove them. It amazes me that I'm apparently the only one who has
asked this question, as the documentation has been missing/wrong for
several versions.
I've come to the conclusion that I must not have auditing (traditional --
not unified yet) configured correctly. That, or no one asks what privs
were granted to trigger an audit row from being generated.
Sigh.
Rich
On Wed, Jun 10, 2020 at 8:04 AM Rich J <rich242j@xxxxxxxxx> wrote:
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
