Error 229

Troubleshooting SQL Server

Troubleshooting

Error 229

Severity Level 14
Message Text

%ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.

Explanation

This error occurs when a Microsoft® SQL Server™ user attempts an action, such as executing a stored procedure, or reading or modifying a table, for which the user does not have the appropriate privileges.

Action

Any user with full-control over the object in question (such as the object owner or system administrator) can grant the necessary privileges to the user requiring access to the object.

See Also

Errors 1 - 999

EXECUTE

GRANT

Managing Permissions

SELECT

UPDATE