SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Problem setting up Data Change Auditing

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Problem setting up Data Change Auditing
Author Message
Liana Rattansingh



Joined: 03 Aug 2006
Posts: 2

Post Problem setting up Data Change Auditing Reply with quote

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.

Thu Aug 03, 2006 12:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Re: Problem setting up Data Change Auditing Reply with quote

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.

Thu Aug 03, 2006 3:12 pm View user's profile Send private message
Liana Rattansingh



Joined: 03 Aug 2006
Posts: 2

Post Re: Problem setting up Data Change Auditing Reply with quote

Thanks for the prompt response.
I executed the script as you suggested and was able to audit data changes
made to tables successfully.

Thanks for your help.

Liana

: 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;
: /

Thu Aug 03, 2006 9:21 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Re: Problem setting up Data Change Auditing Reply with quote

Thank you for the status update.

: Thanks for the prompt response.
: I executed the script as you suggested and was able to audit data changes
: made to tables successfully.

: Thanks for your help.

: Liana

Thu Aug 03, 2006 9:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Hi,

This is a technical support forum, dedicated to supporting software products made by SoftTree Technologies.

SysOp
Sat Jun 20, 2009 10:51 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.