All Forums Database
engmalaa 3 posts Joined 06/14
30 Sep 2014
Disable Updates on specific column.

Kindly, I need a solution to disable updates on spesefic column. If there is any solution other than using trigger it will be great.
Mohammad Alaa

Dixxie 58 posts Joined 12/10
30 Sep 2014

Hi engmalaa,
You will Grant Update only on specific columns to a Role or User.
GRANT UPDATE("Column_x") ON "Database_x"."Table_x" TO "x_ROLE"

You must sign in to leave a comment.