Results 1 to 7 of 7

Thread: User Passwords

  1. #1
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

    Unanswered: User Passwords

    Is there a way that I can prevent SQL Authenticated users from changing their passwords?

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Quote Originally Posted by AnSQLQuery
    Is there a way that I can prevent SQL Authenticated users from changing their passwords?
    Just update sp_password

  3. #3
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62
    Thanks, I set the permissions on sp_password to restrict anyone except administrators. Do you think that will be ok?
    Last edited by AnSQLQuery; 04-27-04 at 20:47. Reason: I'm a dumb@$$

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Yes. They can't change it without that.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Execute 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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Not if he specifically denied them access. Why confuse the issue this way????
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  7. #7
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62
    Quote Originally Posted by Satya
    Execute 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.
    I don't understand that, but I did connect as the user, and tried to change the password with no success. I connected back as an admin, and was able to change the password. That's what I was looking for. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •