How to solve Oracle Database Error 1750 (ora-01750)

Oracle Error Code
   ora-01750

Description
   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.
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.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-01650    ORA-01651    ORA-01653    ORA-01750    ORA-01751    ORA-01752    ORA-01753  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares