Post reply

Doubt about security option

  • July 9, 2010 at 2:34 pm

    #387318

    I was changing a security permission from an especific user and I've noticed an option that I had not notice before. It is the "specify old password" checkbox. I made some tests and I saw that if I inform it or not, have no difference. I'm able to change the password without informing that... Then my question is: When is it necessary or obligate to check this option?

    Rafael Melo - Br

  • July 13, 2010 at 7:41 pm

    #1192478

    Hi,

    The difference is that if a user doesn't specify old password then he/she must have CONTROL SERVER permission to change thier own password.

    In order to give users ability change thier own passwords @old parameter used in sp_password stored procedure. It means that this stored procedure could be used in applications for the password changes.

    http://msdn.microsoft.com/en-us/library/ms174428.aspx

  • July 14, 2010 at 5:19 am

    #1192676

    Hi Mega,

    Thanks a lot for your replying. You really solve my doubt.

    Regards,

    Rafael Melo - Br

Viewing 3 posts - 1 through 2 (of 2 total)

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