Tag Archives: ORA-01750

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

oracle

ORA-01750: UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
Cause: 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: 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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/