Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Unanswered: Allowing SQL Users to change password

    Hi guys,

    Is there anyway to allow SQL Server users to change their own passwords without giving them rights to "db_securityadmin" ?

    Our M$ adviser suggested creating our own app using SQL NS and DMO to do it.

    Is there any easier method, reference, download sample from the web?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    from qa:

    sp_password 'oldpassword', 'newpassword'

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Without giving them sysadmin or securityadmin , is it possible?
    I mean ..just changing their own password...
    I wrote this:
    EXEC sp_password '123', '456', 'test1'


    I got this error:

    "Only members of the sysadmin role can use the loginame option. The password was not changed."

    But I read this in Books Online, can't really understand it yet...:
    Permissions
    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.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  4. #4
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    woppps...of course....just exclude the loginname....sorry bout that....
    okay ..thanks..it works!

    EXEC sp_password '123', '456'
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

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