Database Error Messages

ORA-01750

INSERT, REFERENCES or UPDATE privileges may only be revoked from the whole table, not by column.

Cause

Although it is possible to grant INSERT, REFERENCES or UPDATE privileges on a column-by-column basis, it is only possible to REVOKE them on an entire table.


Action

Do not specify columns. To revoke INSERT, REFERENCES or UPDATE privileges for certain columns, use REVOKE on the entire table and GRANT the privilege for specific columns.