Did you execute the script that the GUI copied to the clipboard while installing this feature? That script grants DB_AUDIT several privileges required for the processing including EXEC on several SYS.DBMS_xxx packages : Hi, : I am auditing an Oracle 9i database. : When I click on Tools-Schedule Periodic Archiving, I get the error: : "Database not available. ORA-01031: insufficient privileges" : I am logged on as 'sys' and my JOB_QUEUE_PROCESSES parameter is 4. : The DB_AUDIT user has select privileges on DBA_JOBS, as well as : execute privileges on DBMS_JOB : Please help. : Thanks, : Liana
|