Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-12-01 : 09:24:37
|
| I can't revert from dbo to Public because one stored procedure usesEXEC 'string'and returns permission denied on the referenced tables.Is there a workaround for this?SamC |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-01 : 09:33:21
|
| No. The public role must have permissions on the objects referenced in the string.Can you post the offending procedure? There may be a way to rewrite it to not need dynamic SQL, or at least less of it. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-12-01 : 10:57:55
|
| Rob,Thanks for offering, I'll work on recoding it and if I have problems, I'll seek out your help.Nuts to EXEC. Sam |
|
|
|
|
|
|
Public role and EXEC