Privilege revoked on a table - SQL*Loader-926: OCI error
bsac14Feb 1 2011 — edited Feb 1 2011During recent maintainence activity , a table was exported & imported , deleted , truncated & dropped.After the activity an user lost its privilege on the table and a job related to this table has been failing with the below error
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table xyz.abc_def
ORA-01031: insufficient privileges
The privileges were granted on the table once again and since then the job has been successful , however we are unable to find the root cause which was responsible for the revoking of these privileges.
Any suggestions and insight into this would be very helpful and much apprciated.