FIX: Permission Denied Error 229 Updating Table with DBID>10Last reviewed: April 9, 1997Article ID: Q158808 |
The information in this article applies to:
SYMPTOMSA non-system administrator (SA) user will receive a Permission Denied error message (number 229) when he or she tries to update a table through a stored procedure, even if the user has permission to run the stored procedure. If the SA or database owner (DBO) runs the stored procedure first, the user will then be able to use the stored procedure. This problem occurs when the following sequence of events occurs:
WORKAROUNDTo work around this problem, do one of the following:
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider. Additional Reference Words: |
Keywords : kbbug6.50 kbfix6.50.sp2 kbusage SSrvStProc
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |