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/17/05


Date: Mon, 17 Oct 2005 11:09:12 +0200

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!
>
> 


Relevant Pages

  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)
  • New Login Question
    ... The database login ... >dropdown always has master listed. ... >what is the significance of the database dropdown on the ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776:
    ... you need to manually refresh the ... use master ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... Then after, trying to grant that new login db_owner permissions, for ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Default Login?
    ... The guest database user provides logins with a security context when ... they haven't been explicitly granted database access. ... You can ignore the default login reported by xp_loginconfig. ... > Master Database. ...
    (microsoft.public.sqlserver.security)