databse questions

[David]

Hello,

What I want to create is a web front with ASP.NET 2.0 for a database that
will be accessed by different clients. The data will be held in one database
ie.all customer deatils for all clients will be in one table. However the
different clients must not be able to see the others data.

Can anyone offer any advice.

Thanks

 

[Consultant]

use role based security
http://msdn.microsoft.com/netframework/default.aspx?pull=/library/en-us/dnnetsec/html/foundstone.asp