Re: setup a sql login which can only reset password


Do you mean that I reset with the old password?


"Tibor Karaszi" wrote:

Hmm, just as a test, does it work if you provide the old password? (I
know it isn't what you are looking for, but just as a troubleshooting
measure...)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"sarah" <sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:264F1183-8448-41D6-8A95-2564A1752CB2@xxxxxxxxxxxxxxxx
Hi Tibor,

I tried and it gives the helpdesk the same error saying
"Cannot alter login ' xxx', because it doesn't exist or you do not
hav
permission"

I don't understand. This account has security admin right as well.

any idea?

Thanks
Sarah

"Tibor Karaszi" wrote:

Did you try GRANT ALTER ANY LOGIN TO loginName?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"sarah" <sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2A35FDE1-1666-4E4A-8D2F-8FC922F7FE85@xxxxxxxxxxxxxxxx
Hi,

I'm using sql2005. I want to setup a sql login for our helpdesk
to
reset sql
login password only.

Please advice,

Thanks
Sarah




.

Relevant Pages

  • Re: setup a sql login which can only reset password
    ... I couldn't test it right now, because if I login as helpdesk, i reset the ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: setup a sql login which can only reset password
    ... doing the reset. ... My tests do indicate that you are able to change pwd for a login if you have ALTER ANY LOGIN. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: setup a sql login which can only reset password
    ... Tibor Karaszi, SQL Server MVP ... I tried and it gives the helpdesk the same error saying ... "Cannot alter login ' xxx', because it doesn't exist or you do not hav ...
    (microsoft.public.sqlserver.server)
  • Re: 64bit insert delays
    ... Tibor Karaszi, SQL Server MVP ... > we/users can query when mails were processed by the antispam system, ... this sounds like you are selecting from some other table than the one inserting into and you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Truncating Log Files
    ... Tibor Karaszi, SQL Server MVP ... I have ran dbcc loginfoand used found that I have about 136 Gig at ... my LSN for Log Shipping and possibly break my Mirroring? ...
    (microsoft.public.sqlserver.server)
Loading