Re: Alter User for domain user
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 6 May 2008 13:08:01 -0400
Try:
ALTER USER [domain\username] WITH DEFAULT_SCHEMA=SchemaName
or
ALTER USER 'domain\username' WITH DEFAULT_SCHEMA=SchemaName
--
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:Xns9A9666B02562FDavidWalker@xxxxxxxxxxxxxxxx
SQL 2005: If I try to do this:
ALTER USER domain\username WITH DEFAULT_SCHEMA=SchemaName
I get a message that says "invalid syntax near '\'".
The syntax for ALTER USER says that the first parameter is the user name,
and according to the list of users listed in Security/Users in Management
Studio, there IS a user called "domain\username". So this command should
work!
The underlying issue is that I'm trying to assign a default schema to the
account of the individual user "domain\username". Per KB article 918346, I
have given this individual user account permissions; the permissions are
not assigned by membership in a group.
I know that "you cannot assign a default schema in SQL Server 2005 to a
Windows-authenticated set of users" (same KB article).
Can I accomplish what I am trying to do, that is, have the user "domain
\username" get a default schema assigned?
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
- Alter User for domain user
- Prev by Date: Alter User for domain user
- Next by Date: Re: Alter User for domain user
- Previous by thread: Alter User for domain user
- Next by thread: Re: Alter User for domain user
- Index(es):
Relevant Pages
|
