October 5, 2001 at 1:34 pm
can non-SA accounts change their own passwords - either thru query analyzer or enterprise manager?
Matthew Mamet
October 5, 2001 at 1:58 pm
yes.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 9, 2001 at 12:28 pm
ok, i'll bite.
How??!?!?
Matthew Mamet
October 10, 2001 at 12:53 am
Use:
sp_password @old = 'Old PAssword' , @new = 'New Password', @loginame = 'Login Name'
October 13, 2001 at 3:21 am
Any way to restrict this access! This is sometimes too dangerous!
quote:
Use:sp_password @old = 'Old PAssword' , @new = 'New Password', @loginame = 'Login Name'
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
October 13, 2001 at 6:27 am
I believe execution of sp_password is limited to members of the sysadmin and security admin roles. Take a look at the source to sp_password.
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply