Re: Alter User for domain user
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 6 May 2008 17:38:20 -0400
What roles do you have? Are you a member of the sysadmin fixed server role.
IIRC, that would make your default schema dbo.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Walker" <none@xxxxxxxx> wrote in message
news:Xns9A969A51BEB7BDavidWalker@xxxxxxxxxxxxxxxx
"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in
news:#UC$Z$6rIHA.672@xxxxxxxxxxxxxxxxxxxx:
Is the user name a domain group instead of a user?
The user is a member of a domain, but it is not a group itself. The
user name is OurDomainName\davidw. davidw is my domain logon.
A group cannot
have a default schema.
I read that in the KB article.
Does the schema exist? You can alter the user
without the schema being created first.
Yes, the schema already exists.
Also, check out:
http://technet.microsoft.com/en-us/library/ms176060.aspx
It says that a backslash cannot be part of the user name. Perhaps you
can map the [domain\username] login to a user named [username].
The Alter User syntax worked (appeared to work) when I put brackets
around the domain\username.
I still would like for my username to have a default schema. When I
connect to the server with Windows Authentication, the default schema is
not mapped. (I used to have the dbo role, but that's not the case any
more. I know that a user with the dbo role doesn't have a default
schema.)
What can I do to beat this into submission?
Thanks.
David Walker
.
- Follow-Ups:
- Re: Alter User for domain user
- From: David Walker
- Re: Alter User for domain user
- References:
- Alter User for domain user
- From: David Walker
- Re: Alter User for domain user
- From: Tom Moreau
- Re: Alter User for domain user
- From: David Walker
- Re: Alter User for domain user
- From: Tom Moreau
- Re: Alter User for domain user
- From: David Walker
- Alter User for domain user
- Prev by Date: Re: Alter User for domain user
- Next by Date: Re: SQL2005 non-administrator Service Account
- Previous by thread: Re: Alter User for domain user
- Next by thread: Re: Alter User for domain user
- Index(es):
Relevant Pages
|
|
