Home > OS >  Microsoft SQL Server 2012 column level permissions
Microsoft SQL Server 2012 column level permissions

Time:09-23

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.

  • Related