I'm developing an application that will grant access to specific crystal reports based on what groups a user is a member of. I want to use as a user list, all the users in a Windows Domain - are there any .NET classes that grant access to this? I'm searching the documentation as well, but that doesn't seem to have the information I require (though probably I'm looking in the wrong place).

Thanks

if I understand you properly- you want to know how to determine what groups a specified user is in?


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

What is your Back end Database?



Sal

Nope, just needed a way of getting all users in a domain. I've worked it out now using System.DirectoryServices namespace, that bundles all the ADSI COM stuff. Back-end database will probably be either SQL Server or MySQL (once SourceForge sort out their .NET data provider for MySQL!)

Thanks for the responses!

Just use windows authentication with SQL Server. This will allow you to use the current domain users for security. If a user does not have access to the report, it will not open with data anyway.

With this you can grant privileges to the windows groups as well, and it simplifies security development.



Sal

I shouldn't have said groups, it is somewhat misleading. Basically, I'm developing a new database to manage what crystal reports someone has access to. To do this, I will use their windows username (read using the system.securityprinciple you mentioned) and interrogate a 'groupmembership' table in my database, which provides a many-to-one relationship back to the 'groups' table in the same database. Because I was using a windows username, I needed to get a list of all users in the domain, so I could build the 'groupmembership' table - one user has many groupmemberships, one group has many groupmemberships. I just didn't know how to get at a list of users in a domain, having never used ADSI before!

Thanks,

Jaucourt