I wish to determine, from my C# application, if the current user has admin or owner rights to the database they are connected to.
I beleive I have all the information required:
Servername Database name Windows/Database auth username (If database auth) password (if database auth)
I'm trying to find a way that using the smo objects (smo.user), but as of yet I cant quite work it out:
- How to get the appropriate user
- How to determine if that user is an admin/owner.
Any tips would be appreciated.
If I have posted to the wrong forum, let me know - I couldnt find one that was obviously more appropriate.
View Complete Post