SQL database users/roles

[nologo]

hi all, is it possible to Incorporate the database users/roles element
in my c# application?
i'm trying to restrict areas of the application for certain users..if
i could put these users into a role and then call that role only
allowed to access this area - that would be perfect.

[Mr. Arnold]

Re: SQL database users/roles


"nologo" <zell71@hotmail .comwrote in message
news:198ddfa9-d23c-451b-b7fe-6fdd4edfb9b4@d5 g2000hsc.google groups.com...

hi all, is it possible to Incorporate the database users/roles element
in my c# application?
i'm trying to restrict areas of the application for certain users..if
i could put these users into a role and then call that role only
allowed to access this area - that would be perfect.

<http://www.codeguru.co m/csharp/.net/net_security/authentication/article.php/c7415/>

[DeveloperX]

Re: SQL database users/roles

On 19 Feb, 09:23, nologo <zel...@hotmail .comwrote:

hi all, is it possible to Incorporate the database users/roles element
in my c# application?
i'm trying to restrict areas of the application for certain users..if
i could put these users into a role and then call that role only
allowed to access this area - that would be perfect.

You can use Microsoft.SQLSe rver.SMO which is the SQL Server management
objects. Alternatively wrap a call to sp_helprolememb er which will
give you a list of which users are in which roles. After that Mr
Arnolds suggestion of using custom Principal is a good one, just make
your implementation return info based on what you queried using the
either SMO or the SP above.

[nologo]

Re: SQL database users/roles

many thanks guys, i'll look into that this afternoon!thank s