Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Tue, 11 Jul 2006 07:24:33 -0700
Try:
GRANT CREATE DATABASE TO [DomainName\DomainUserName]
(Use square brackets instead of quotes.
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Joe" <jwdaigle@xxxxxxxxxxxxx> wrote in message
news:%236qm7LPpGHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
Is it possible to GRANT CREATE DATABASE TO a domain user account or group?
I have both SQL Express 2005 & SQL 2005 Developer edition machines, both
have windows integrated security enabled.
I am trying to do something like:
GRANT CREATE DATABASE TO 'DomainName\DomainUserName'
I get an error that complains about the '\' being incorrect syntax.
However, if I do a
sp_addsrvrolemember 'DomainName\DomainUserName', 'dbcreator'
that works like a champ.
I have also tried this same test on a machine that is not part of the
domain (changing domain name to machine name of course).
Is this supported? How can I do it? Can I specify a domain group in it
instead?
Thanks for any information,
Joe
.
- Follow-Ups:
- Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- From: Steven Cheng[MSFT]
- Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- References:
- Prev by Date: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Next by Date: Newbie needs help
- Previous by thread: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Next by thread: Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Index(es):
Relevant Pages
|
|
