Execute permission lost after database migration with attach

I have moved a SQL2000 database from one machine to another by detaching and
attaching the database from enterprise manager.
All went well except that I have lost execute permissions on a bunch of
stored procedures for non admin users. I have not lost the user but rather
it's permissions.
Has anyone else has experienced this problem?
Is this normal? How can I avoid this happening?
The first machine was a Win 2000 machine and the target was Windows 2003.
I'm not sure that it matters
Thanks,
DimitrieHi,
Looks like the mapping between the logins and users are lost after the
restore. You could the system procedure sp_change_users_login to recreate
the mapping. See the details of the procedure in books online.
Thanks
Hari
SQL Server MVP
"dimitrie" <dagafitei@.yahoo.com> wrote in message
news:%23N7B8y$rEHA.2000@.tk2msftngp13.phx.gbl...
>I have moved a SQL2000 database from one machine to another by detaching
>and attaching the database from enterprise manager.
> All went well except that I have lost execute permissions on a bunch of
> stored procedures for non admin users. I have not lost the user but rather
> it's permissions.
> Has anyone else has experienced this problem?
> Is this normal? How can I avoid this happening?
> The first machine was a Win 2000 machine and the target was Windows 2003.
> I'm not sure that it matters
>
> Thanks,
> Dimitrie
>|||> Looks like the mapping between the logins and users are lost after the
> restore. You could the system procedure sp_change_users_login to recreate
> the mapping. See the details of the procedure in books online.
Agree with Hari. Just an addition: sp_change_userslogin works for SQL logins
only. For Win logins, you have to download additioal procedures from MS site
(file mapsids.exe). Check the article at
http://support.microsoft.com/kb/240872/EN-US/.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com