%ls permission denied on column ‘%.*ls’ of object ‘%.*ls’, database ‘%.*ls’, owner ‘%.*ls’.

Details
Product: SQL Server
Event ID: 230
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: %ls permission denied on column ‘%.*ls’ of object ‘%.*ls’, database ‘%.*ls’, owner ‘%.*ls’.
   
Explanation
The user who issued the query does not have the appropriate permissions for the specified column in the specified table.
   
User Action
Either grant the user permissions for the specified column or rewrite the query so that it does not reference the column to which the user does not have permissions. Be aware that “SELECT *” will try to return all columns, not just those to which the user has permissions. Therefore “SELECT *” may need to be rewritten to “SELECT column_list“.

Be aware that DENY, even through a group or role membership, overrides GRANT permissions.

For more information about granting permissions, see “Permissions” in Books Online.

Related:

Leave a Reply