1

I have a Oracle 11gR2 database and I want to audit all select operations on SYS.USER$ table for which users select on this table. When I try this command (I'm trying to run this command with SYS user):

audit select on SYS.USER$;

It gives error below:

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered

How can I audit this table?

Best regards,

2

In Oracle 11g this cannot be audited. There are ways of doing it in 12c and up. That said, only users with the "select any dictionary" privilege should be able to select from that table, and anyone with that privilege should be trusted.

  • Thank you so much sir. – jrdba Jul 24 '20 at 11:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.