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?