cancel
Showing results for 
Search instead for 
Did you mean: 
TimStVCS
Pilgrim

SQL Login - Sufficient Privileges

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?

Thanks in advance!
Labels (1)
0 Kudos
2 Replies

Re: SQL Login - Sufficient Privileges

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.
0 Kudos
TimStVCS
Pilgrim

Re: SQL Login - Sufficient Privileges

Thanks Christopher, this helps me out!

Tim
0 Kudos