Just guessing that during setup of DB_AUDIT user you didn't execute the required script that grants to DB_AUDIT permissions to select from SYS.V_$SESSION and some other views and packages. To deal with it you can drop DB_AUDIT user and start over or you can execute the following script that will cover all required permissions for all types of available functionality. GRANT CONNECT TO db_audit; GRANT SELECT ON sys.v_$session TO db_audit; CREATE VIEW db_audit.v$session AS SELECT * FROM sys.v_$session; GRANT SELECT ON sys.v_$mystat TO db_audit; CREATE VIEW db_audit.v$mystat AS SELECT * FROM sys.v_$mystat; GRANT SELECT ANY TABLE TO db_audit; GRANT EXECUTE ON sys.dbms_lob TO db_audit; GRANT EXECUTE ON sys.dbms_output TO db_audit; GRANT EXECUTE ON sys.dbms_job TO db_audit; GRANT EXECUTE ON sys.dbms_utility TO db_audit; GRANT SELECT, DELETE ON sys.aud$ TO db_audit; / : From the "Set Data Options" page, when I select a table to : be audited and click on the "Proceed" button, I get a : 'database processing error'. : "It says that ORA-00000 : Object compiled with errors : Line 14, PL/SQL: ORA-00942 : table or view does not exist or insufficient : privileges : Line 16, PL/SQL: ORA-00942 : table or view does not exist or insufficient : privileges" : I am using an Oracle 9i database, and am logging in : as 'sys', which should have privileges to do everything. : Please help.
|