users change passwords thru query analyzer?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

SSC Guru

Points: 736478

October 5, 2001 at 1:58 pm

yes.

Steve Jones

Matthew-12035 Right there with Babe Points: 735 More actions · Answer 2

Right there with Babe

Points: 735

October 9, 2001 at 12:28 pm

ok, i'll bite.

How??!?!?

Matthew Mamet

patilds SSChasing Mays Points: 615 More actions · Answer 3

Use:

sp_password @old = 'Old PAssword' , @new = 'New Password', @loginame = 'Login Name'

paras_98 SSCrazy Points: 2994 More actions · Answer 4

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 5

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