Hello, I was wondering if there were any way to determine whether or not the supplied credentials in the SQL Login dialog had a certain level of privileges? For example, a user may specify Windows Authentication and be successfully authenticated but that does not mean the supplied credentials have the necessary privileges in SQL Server to be able to perform some or all of the actions that the SQL scripts included in the installer will execute. Is there a way to indicate that the supplied credentials need dbo access to a certain database?
The InstallShield sql pattern is a little weak here. AFAIK there isn't anyway os selecting data and mapping it back to properties. You could try to do a privileged, non-destructive operation, catch the error and try to assert a prettier error message to InstallShield but at the end of the day I'm suspecting you might have to roll a custom action.
