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

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

Tags:
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"
Regards.
 
 

You must sign in to leave a comment.