This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: SQL Login - Sufficient Privileges
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 27, 2008
05:38 PM
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!
Thanks in advance!
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 27, 2008
08:22 PM
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.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 28, 2008
10:12 AM
Thanks Christopher, this helps me out!
Tim
Tim
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)