Oracle database error code ORA-01750 – UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

Oracle Database Error Code ORA-1750 Description :
UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
Error 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.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , , ,
No Comment Yet   
«
»