| Event Id | 230 | | Source | MSSQLServer | | Description | %ls permission denied on column %.*ls of object %.*ls, database %.*ls, owner %.*ls. | | Event Information | CAUSE:
The user who issued the query does not have the appropriate permissions for the specified column in the specified table.
RESOLUTION:
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. | | Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 230 |
|
|
