Re: How to change sql login username instead of create new one.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/20/05
- Next message: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Previous message: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- In reply to: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Next in thread: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Reply: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Oct 2005 08:41:48 +0200
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.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Gabi Tianu" <gabi_tianu@hotmail.com> wrote in message news:eS3wd$T1FHA.1108@TK2MSFTNGP14.phx.gbl... > 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 > > "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message > news:uW5cTJ80FHA.916@TK2MSFTNGP10.phx.gbl... >> Hi, >> >> As Tibor mentioned; In SQL 2000 you can not rename a SQL Server Login or database user. >> >> Thanks >> Hari >> SQL Server MVP >> >> "Pleo" <rx8@hotmail.com> wrote in message news:ON0lytv0FHA.404@TK2MSFTNGP09.phx.gbl... >>> 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. >>> >>> >>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> ??? >>> news:%23R4Ixpv0FHA.3068@TK2MSFTNGP10.phx.gbl ???... >>>> 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. >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://www.solidqualitylearning.com/ >>>> Blog: http://solidqualitylearning.com/blogs/tibor/ >>>> >>>> >>>> "Pleo" <rx8@hotmail.com> wrote in message >>> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl... >>>> > As title, thanks! >>>> > >>>> > >>>> >>> >>> >> >> > >
- Next message: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Previous message: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- In reply to: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Next in thread: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Reply: Gabi Tianu: "Re: How to change sql login username instead of create new one."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
