Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AUDIT FUNCTION NOT EXISTS

user13343313Jun 19 2018 — edited Jun 19 2018

Hello,

When I enable "AUDIT NOT EXISTS", I can query the DBA_AUDIT_EXISTS table to check what tables or views the users are failing to access, with queries that fail with error "ORA-00942: table or view does not exist".

However, when users try to access non-existing functions, and they get error "ORA-00904: invalid identifier" on the name of the function caused by lack of privileges, how can I, as a DBA, know what identifiers are users failing to access?

Is there a BDA_AUDIT_ table that I can query for this information, if I enable some audit option that I don't know yet? Otherwise, is there some table where I can query for "ORA-" errors that users received, if I enable some specific audit option?

Do you have any suggestions?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2018
Added on Jun 19 2018
1 comment
787 views