Disable Updates on specific column.

Database

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 (1)
1 REPLY
Enthusiast

Re: Disable Updates on specific column.

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.