Oracle DB Error ORA-01750 UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

The following is the cause of this error:

Although it is possible to GRANT update privileges on a column-by-column basis, it is only possible to REVOKE them for an entire table.

Action you can take to resolve this issue: Do not identify specific columns. To revoke update privileges for certain columns, use REVOKE for the entire table and GRANT the user privileges for specific columns.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related