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 |
|
bbasir
Yak Posting Veteran
76 Posts |
 Posted - 2008-04-12 : 17:50:07
|
| I run the following query...using sql analyzer dbo.aCVChangeSQLPassword 'user1','user1',''I am logged in as user1 in the sql analyzer...It chnages my password, in sql server, however gives me this message...Grantor does not have GRANT permission.Password changed.(1 row(s) affected)Server: Msg 4613, Level 16, State 1, Procedure aCVChangeSQLPassword, Line 27Grantor does not have GRANT permission. |
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-12 : 18:18:05
|
| Forgot to mention that inside this procedure, I am using the system procedure to chnage sql password.sp_password |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-12 : 19:01:08
|
| What's line 27 in your sp? |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-12 : 19:33:34
|
| exec sp_password @old,@new,null |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-12 : 20:40:21
|
| Thanks rmiao, but solved the issue...The GO was left out between the end of the stored procedure and the GRANT statement - which made the GRANT execute every time the proc was called - which the calling user didn't have permission to do. |
|
|
|
|
|
|
Grantor does not have GRANT permission.