 |
|
|
|
Next: xp_cmdshell no longer allowing remote access
|
| Author |
Message |
External
Since: Jun 25, 2008
Posts: 45
|
(Msg. 1) Posted: Wed Jul 30, 2008 6:03 am
Post subject: reset password
Archived from groups: microsoft>public>sqlserver>security (more info?)
|
|
|
Hi,
Idealy I want to grant helpdesk group "reset password" for sql logins
permission only. Is this possible? Do I have to add them to securityadmin
which can grant, deny etc?
Thanks,
Sarah |
|
| Back to top |
|
 | |
External
Since: Apr 21, 2004
Posts: 441
|
(Msg. 2) Posted: Wed Jul 30, 2008 10:12 am
Post subject: Re: reset password [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Consider granting the ALTER ANY LOGIN permission to the help desk group.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sg" wrote in message
Hi,
Idealy I want to grant helpdesk group "reset password" for sql logins
permission only. Is this possible? Do I have to add them to securityadmin
which can grant, deny etc?
Thanks,
Sarah |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 3) Posted: Wed Jul 30, 2008 10:12 am
Post subject: Re: reset password [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Or create a stored procedure with the ALTER LOGIN statement and grant them
execute permission to the procedure.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom Moreau" wrote in message
> Consider granting the ALTER ANY LOGIN permission to the help desk group.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "sg" wrote in message
>
> Hi,
>
> Idealy I want to grant helpdesk group "reset password" for sql logins
> permission only. Is this possible? Do I have to add them to securityadmin
> which can grant, deny etc?
>
> Thanks,
> Sarah
> >> Stay informed about: reset password |
|
| Back to top |
|
| |
External
Since: Jun 25, 2008
Posts: 45
|
(Msg. 4) Posted: Wed Jul 30, 2008 12:18 pm
Post subject: Re: reset password [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks so much Tom, it works.
"Tom Moreau" wrote:
> Consider granting the ALTER ANY LOGIN permission to the help desk group.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "sg" wrote in message
>
> Hi,
>
> Idealy I want to grant helpdesk group "reset password" for sql logins
> permission only. Is this possible? Do I have to add them to securityadmin
> which can grant, deny etc?
>
> Thanks,
> Sarah
>
> >> Stay informed about: reset password |
|
| Back to top |
|
| |
| Related Topics: | SQL 2005 Password Changes - Hi, I have some users on a SQL 2005 box that connect via SQL Authentication with password policy enforcement. If their password expires, they can try to connect via Management Studio, and they will be prompted to change their password. Is there a..
Password Audit - Hello All, I am in the process of auditing a SQL server and was checking for NULL passwords. I ran the following query select name, password from master..sysxlogins where password is NULL. It returned the expected windows accounts with NULL..
Change Password - I created a SQL login name which I'm specifically intending to use as the login id that can allow a user to change their own password. I currently have this login id permission checked off as 'Security Administrators' in the Server Roles tab but I..
password expiration - How do we enable password expiration on sql 2005. Just upgraded.
SQL Logons and password - The company I am working for have had a very lax attitude to security. I am slowly trying to tighten this up as I go along and most servers now have strong sa passwords and restricted use of databases. However for various reasons I am unable at this.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
