I hope this is the right place top post this, apologies if not and please advise.
A request has been placed by an application provider which asks for the following:
1 Their application sql login is granted sa rights ( a definite no there)
2 Their application can enable CLR integration, any product update may or may not introduce further "features". As a minimum CLR is enabled and the account (or database) has rights (is_trusted) to CLR
3 Their account sets up broker services for the application to function.
My question is twofold; is it possible to allow a third party application to use CLR and broker service with minimal rights? and secondly if not possible what is the best argument to resist such a request?
This will be a potential SQL 2017 application deployment to an AO environment with multiple application databases present.
- This topic was modified 2 years, 2 months ago by HappyGeek.