CODEWITHSUNDEEP
sqlsql-serversql-server-2012
Ravi Teja Gadi
Ravi Teja Gadi

Reputation: 2145

Microsoft SQL Server 2012 column level permissions

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.

Upvotes: 0

Views: 1071

Answers (1)

Jose Gutierrez Paliza
Jose Gutierrez Paliza

Reputation: 1428

Based on this article 1, only you can grant SELECT, REFERENCES, and UPDATE permissions on a column.

Upvotes: 2

Related Questions