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 |
|
t1g312
Posting Yak Master
148 Posts |
 Posted - 2004-08-15 : 07:40:05
|
| Hi all,I want my users to be able to change their Sql server password from the client VB application. I've assigned them the role of db_owner but they can't access sp_password. What do I do?ThanksAdi-------------------------/me sux @sql server |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-15 : 08:33:40
|
BOL:quote:
PermissionsExecute permissions default to the public role for a user changing the password for his or her own login. Members of the securityadmin and sysadmin fixed server roles can change the password for another user's login.
Kristen |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-15 : 17:11:09
|
| Passwords are associated with the server login not with a database so dbowner (or and database permissions) won't help.What is the error message you are getting?You won't be able to use it for integrated security and can only change the users own password - i.e. that for the current login.Set the login name to null or leave it to default when calling the sp.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-15 : 18:04:01
|
| And, just as an fyi, you need to remove everyone from db_owner immediately. You probably know that. You should be able to grant them EXEC on sp_password and follow the advice of Nigel. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
t1g312
Posting Yak Master
148 Posts |
Posted - 2004-08-16 : 00:23:34
|
| Hi nr,The error message I'm getting is:"Only members of the sysadmin role can use the loginame option. The password was not changed."Adi-------------------------/me sux @sql server |
|
|
|
t1g312
Posting Yak Master
148 Posts |
Posted - 2004-08-16 : 00:25:36
|
| Thanks guys!Adi-------------------------/me sux @sql server |
|
|
|
|
|
|
Changing Password