December 7, 2007 at 3:01 am
I have a bit complicated stored procedure where I use create temporary table option. Execute permission for one user group was assigned but when they run this procedure from .net application they got error message telling smth like "no permission for tmpCase (name of temporary table created in first step of stored procedure) ...".
Does anybody know what kind of permissions must be assigned to users in order to run this procedure?
Help. please.
December 7, 2007 at 7:07 am
tmpCase would not be the name of a temporary table. Temp tables need to start with # or ## (two pound signs is a global temp table).
I would expect your table to be named #tmpCase. Since it is not, it is a real table meaning the permissions could be based on the user permissions to the actual object depending on ownership chaining and your schemas.
December 7, 2007 at 7:11 am
Michael Earl (12/7/2007)
tmpCase would not be the name of a temporary table. Temp tables need to start with # or ## (two pound signs is a global temp table).I would expect your table to be named #tmpCase. Since it is not, it is a real table meaning the permissions could be based on the user permissions to the actual object depending on ownership chaining and your schemas.
thank you, Michael, so much. I have just realised the same, a few minutes ago. Sounds unbelievable, but it is true. Never mind. Hasch is missing in front of the name, and it caused the problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply