GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- From: "Joe" <jwdaigle@xxxxxxxxxxxxx>
- Date: Tue, 11 Jul 2006 22:04:48 +0800
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: Arnie Rowland
- Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Prev by Date: Re: Network Service Account
- Next by Date: Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Previous by thread: Re: Brute Force Attack
- Next by thread: Re: GRANT CREATE DATABASE TO a domain user account or group in SQL 2005
- Index(es):
Relevant Pages
|
|
