When run the "Audit Trail Update Tables" program on custom tables, whether it is necessary to grant
I have enabled the audit trail on custom table, when ran the cocurrent program AuditTrail Update Tables, get below error.....
Fatal error in fdasql, quitting...
ORA-24344: success with compilation error
Fatal error in fdactr, quitting...
Fatal error in fdactr, quitting...
However, when add the below grant manually......it works fine....that mean it will create all objects without any issues....
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON NAPPCUST.NAPP_CUSTOM_TABLE_PURGE__A TO APPS;
So want to know:
==============
When run the "Audit Trail Update Tables" program on custom tables, whether it is necessary