How to change sql login username instead of create new one.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pleo - 17 Oct 2005 10:05 GMT

As title, thanks!

Reply to this Message

Tibor Karaszi - 17 Oct 2005 10:09 GMT

Can you explain what you mean by "change sql login username"? Are you referring to the login name
(in master) or the user name (in your database)? Anyhow, you cannot change the name of a login or a
user, You will be able to rename a user in 2005, not sure about login, though.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

> As title, thanks!

Reply to this Message

Pleo - 17 Oct 2005 10:16 GMT

I'm not familiar sql. At enterprise server (sql2000) > security > logins >
(want to change name here).
Anyway, I guess it can't be changed there. Thanks.

> Can you explain what you mean by "change sql login username"? Are you referring to the login name
> (in master) or the user name (in your database)? Anyhow, you cannot change the name of a login or a
> user, You will be able to rename a user in 2005, not sure about login, though.
>
> > As title, thanks!

Reply to this Message

Hari Prasad - 18 Oct 2005 09:59 GMT

Hi,

As Tibor mentioned; In SQL 2000 you can not rename a SQL Server Login or
database user.

Thanks
Hari
SQL Server MVP

> I'm not familiar sql. At enterprise server (sql2000) > security > logins >
> (want to change name here).
[quoted text clipped - 10 lines]
> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
>> > As title, thanks!

Reply to this Message

Gabi Tianu - 20 Oct 2005 07:30 GMT

Hi,

Yes, you can rename a SQL Server Login. You have to manually change values
in master.dbo.syslogins and master.dbo.sysxlogins.

Gabi Tianu

> Hi,
>
[quoted text clipped - 20 lines]
>> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
>>> > As title, thanks!

Reply to this Message

Tibor Karaszi - 20 Oct 2005 07:41 GMT

sysxlogins is the name of the table, and syslogins is a view. So, the only place where a change
would be needed is sysxlogins. However, hacking system tables is not supported and Pleo would be on
his own by doing that.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

> Hi,
>
[quoted text clipped - 24 lines]
>>> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
>>>> > As title, thanks!

Reply to this Message

Gabi Tianu - 20 Oct 2005 07:51 GMT

Very good point Tibor. Any unsupported change to the system table allways
has to be done first in a test environment.

> sysxlogins is the name of the table, and syslogins is a view. So, the only
> place where a change would be needed is sysxlogins. However, hacking
[quoted text clipped - 31 lines]
>>>> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
>>>>> > As title, thanks!

Reply to this Message

doller - 20 Oct 2005 09:24 GMT

Hi Gabi,
This is not recommended by microsoft to update or modify system tables.

from
Dollers

Reply to this Message