Change Password of SQL Server Login

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'
VenkatDo 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
>
>