I am connected to the user CUCCP8 and I can check the object is owned by that user still not able to insert data into that.
I am using Oracle 12c R2
SHOW USER
USER is "CUCCP8"
SELECT TABLE_NAME, OWNER FROM all_tables WHERE table_name = 'ACCOUNT';
ACCOUNT CUCCP8
INSERT INTO account
values (3, 3, 3, 3, 3, 3, null, null, null);
Getting below error :
Error starting at line : 12 in command -
INSERT INTO account
values (3, 3, 3, 3, 3, 3, null, null, null)
Error at Command Line : 12 Column : 10
Error report -
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges