getting the role to which a user belongs

[Danzy83]

Hi, I would like to know if it is possible to determine sql role to which a user belongs. I would want my client application to enable and disable some menu items if it is able to determine the sql role to which that user belongs. I'm using Sql Server 2005. Thanks.

[Mycroft Holmes]

Are you talking about the server roles withing sql server or the active directory roles. It would be weird to use server roles to manage your UI and AD roles should be retrieved via the UI.

Never underestimate the power of human stupidity RAH

[Blue_Boy]

Check this[^] and it depend how you plan to manage rights on application.

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.

[Simon_Whale]

Have a read of this article SQL Server 2005: View all permissions (2) - Explode the roles![^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[Danzy83]

Some users will be administrators, and I will create my own roles as well. That means I will check both the server roles and user-defined roles for a database.

[Danzy83]

Blue-Boy you took me to Google. Well I have already googled and didn't find a clear solution. But I will keep trying.