I have a microsoft sql server database and a set of users. Now in my app i want to make some functionality only visible if the user has entered username and password with certain rights (admin). Since the databases and the usernames and their rights can change, how do i check what permissions/rights an microsoft sql server user has?

Check Solution