Restrict UPDATE privileges for a table to specific columns of the table

[former_member620346]

Hello.

We have a custom table in a SAP HANA schema. We need to restrict UPDATE privileges of a specific user to only one column of the table.

Is it possible specific only one column of the table using the GRANT ON TABLE instruccion?

Thanks in advance.

[michael_eaton3 · Accepted solution]

This is't possible with GRANT.

A common technique would be to use a stored procedure to perform the UPDATE, giving the user EXECUTE rights on the procedure.

Michael