Database Security Products (MOSC)

MOSC Banner

Unable to insert into a redacted table.

we are Unable to insert into a redacted table using the below query

---------------------------------------------------

ORA-28081: Insufficient privileges - the command references a redacted object

We are getting the above error when we use the below dml query

INSERT INTO siteplanwf.APPLICANT_DTLS ( APPLICANT_ID,EMIRATES_ID, EMAIL_ID, MOBILE_NO, NAME_E, NAME_A, NATIONALITY_NAME, GENDER, DOB, FILE_NO, UDB_NO, PASSPORT_NO, EID_EXPIRY_DATE,

PASSPORT_EXPIRY_DATE, MYID_USER_ID, APPLICANT_SOURCE_ID, ENTRY_WHEN, ENTRY_WHO, AUTHORITY_NO) SELECT siteplanwf.SEQ_APPLICANT_ID.nextval, EMIRATES_ID, EMAIL_ID, MOBILE_NO, NAME_E, NAME_A, NATIONALITY_NAME,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center