Re: Change Password of SQL Server Login

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 06/06/05 

Date: Mon, 6 Jun 2005 21:08:41 +0100

Do you mean change their own password or change another users password? Any
user can change their own password, if they need to change other users
passwords then they must be a member of the securityadmin or sysadmin fixed
server roles, there's no getting around that. 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Venkat" <tammana@inooga.com> wrote in message 
news:%23gIjK%23paFHA.2420@TK2MSFTNGP12.phx.gbl...
> Can any one tell me how to change a password for a logged in user in sql 
> server? Here the condition is the logged in user is a user who has least 
> privileges and just will have only select permission on database tables. 
> The logged in user does not have any server roles and even he is not a 
> member of db_Owner role. He is not even member Security Administrator 
> which is required to change the password for a user.
>
>
>
>            Can any one give an example to change the password using T-Sql 
> statements for my scenario??
>
>
>
> --
>
> Venkat
>
>
>

Relevant Pages

  • Re: Strange right permissions SQL 2K SP4
    ... JOIN sysusers groups on membs.groupuid = groups.uid ... I recently demoted a Windows 2003 DC Server to a member server. ... I even reinstalled SQL Server on another DC server (trying to get back on ...
    (microsoft.public.sqlserver.security)
  • Re: Security issue when user is member in db_datawriter ?
    ... More precisely it means that this login is a member of the sysadmin ... CREATE LOGIN command. ... You now should have a SQL Server Management Studio Process running under ...
    (microsoft.public.sqlserver.security)
  • Re: Migrating SQL 2000 Clustered Server
    ... Windows 2003 Enterprise server will support up to 8-member clusters; ... 2187 Cumulative Hotfix to your existing cluster before you start the ... You can then add one of the new servers as a member of the cluster. ... You must then run SS2K setup to install the SQL Server binaries on this new ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multiple Clusters with shared passive nodes
    ... Sort of - I'd create all 5 servers as members of a single cluster, then set up 4 instances of SQL Server with cluster server member 1 configured ... While you are able to have cluster member 5 be the failover for all the other instances, there might be a better way to set which member servers can run each instance, but its not difficult to change this at a later date - it might not be an optimal configuration if all the instances are of different memory needs or if you want to handle a situation where more than one cluster member might be unavailable at a time. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Upgrade to Windows 2008 AD DS
    ... server at this stage (as described in the upgrade process), ... other software / roles on this server itself. ... but still retain some Windows 2000 member servers. ... I am investigating server roles on the DCs themselves that are to be ...
    (microsoft.public.windows.server.migration)
Loading