The information in this article applies to:
SYMPTOMS
After creating a stored procedure that selects from a table and a
view into a temporary table, any attempt to execute this new stored
procedure by any user other than the owner of the stored procedure
results in an incorrect "permission denied" error. The other users
getting the "permission denied" error were correctly granted
execute permission on this new stored procedure.
WORKAROUND
To work around the problem, first create the temporary table, and
then insert the data into the temporary table:
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server versions 4.21 and 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words: Transact-SQL
Keywords : kbprg kbbug4.20 kbbug4.21 kbbug4.21a SSrvServer SSrvWinNT |
Last Reviewed: March 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |