Re: [WiX-users] Granting user access to database

2008-10-07 Thread Eitan Behar
install. > > Amy > > -Original Message- > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2008 4:35 AM > To: General discussion for Windows Installer XML toolset. > Subject: [WiX-users] Granting user access to database > > Short qu

Re: [WiX-users] Granting user access to database

2008-10-07 Thread Amy Rosewater
discussion for Windows Installer XML toolset. Subject: [WiX-users] Granting user access to database Short question, and waiting for (hopefully) a short answer: How to grant grant permissions of db_owner to a certain user on a database? TiA, Eitan

Re: [WiX-users] Granting user access to database

2008-10-07 Thread Eitan Behar
Thanks! On Tue, Oct 7, 2008 at 2:03 PM, Dana Gutride <[EMAIL PROTECTED]> wrote: > For integrated auth, use a sqlstring element containing the following where > USERNAME is the domain\username: exec sp_addrolemember N'db_owner', > N'[USERNAME]' > > Dana > > > > On Tue, Oct 7, 2008 at 6:34 AM, E

Re: [WiX-users] Granting user access to database

2008-10-07 Thread Dana Gutride
For integrated auth, use a sqlstring element containing the following where USERNAME is the domain\username: exec sp_addrolemember N'db_owner', N'[USERNAME]' Dana On Tue, Oct 7, 2008 at 6:34 AM, Eitan Behar <[EMAIL PROTECTED]> wrote: > Short question, and waiting for (hopefully) a short answe

[WiX-users] Granting user access to database

2008-10-07 Thread Eitan Behar
Short question, and waiting for (hopefully) a short answer: How to grant grant permissions of db_owner to a certain user on a database? TiA, Eitan - This SF.Net email is sponsored by the Moblin Your Move Developer's challeng