When I try to give column level insert (or) update permissions in SQL Server, I get an error.
Query:
GRANT INSERT, UPDATE ON [db].[dbo].[table]([column]) TO [user]
Error:
Msg 1020, Level 15, State 1, Line 0
Sub-entity lists (such as column or security expressions) cannot be specified for entity-level permissions.
Is there any other way, I can give column-level select/update access to the user.
CodePudding user response:
Based on this article 1, only you can grant SELECT, REFERENCES, and UPDATE permissions on a column.