Hi Eitan, I do something similar in my install with the following under my SqlDatabase node:
<sql:SqlString Id="CreateUser" User="SqlUser" ExecuteOnInstall="yes" SQL="CREATE USER [LOGIN] FOR LOGIN [LOGIN]" Sequence="013" /> <sql:SqlString Id="AssignUserToRole" User="SqlUser" ExecuteOnInstall="yes" SQL="sp_addrolemember 'db_owner', '[LOGIN]'" Sequence="014" /> The [LOGIN] is entered in a dialog during the course of my 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 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 challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
