February 4, 2005 at 6:51 am
We have an application database that has existed for a couple of years in SQL Server version 7. As part of an upgrade we restored this in version 2000. Now we find that not only do we not have execute permission on most stored procedures, we cannot change these permissions, either in GUI or from Query Analyzer. No error is shown, but we cannot grant execute permissions. What's up?
February 4, 2005 at 10:39 am
It is most likely that the link between database users and server logins are broken.
For a start, you want to login as an 'sa' and examine the login information (sp_helpuser shows database user info).
sp_change_users_login can be used to correct the typical cases. (Look in BOL.)
February 4, 2005 at 1:24 pm
Thanks for the tip. It got me going in the right direction. Turns out the trouble originated in a seperate security database that is maintained along with the application database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply