sql server role

[Guest]

I'm hoping someone can poing me to a good resource on this topic

Inside of my vb app, a user logs into a sql database. I'd like to find our which roles he is a member. I would use this to determine which functions to disable

1) Is this a proper way to handle security (the roles in SQL would already disallow writing... the presentation layer would simply not allow functions that would cause SQL Server to give permission denied errors), or is there a better way
2) Where can I find more info? I did google searches on 'sql server roles ado vb', but not want I want..

Eric

 

[Cor]

Hi Eric,

I think this is more a question for the newsgroup

microsoft.public.dotnet.security

an SQL newsgroup

or maybe

microsoft.public.dotnet.framework.adonet.

I will not say you do not get here an answer, but the change in those groups
from up to down is I think much more.

I hope this helps?

Cor