Develop a VS2005/2008 project that produces a RoleGroup (ie Organization) specific ASP.NET User Management System in C#. The limitations are 1 Database and one ASP.NET Application. The primary goal is to enable a user from one of the authorised organizations to login and access records specific to their organization only, although they share a common database and schema.
The 3 primary authentication parameters are RoleGroupID, RoleID and UserID. Data tables may contain a RoleGroupID field to assist with Record level access. Lookup tables may also be RoleGroup specific. All pages, webservices and usercontrols are to be registered and controlled by the database. Database is SQL2005 but may be developed in SQLXpress, Access or XML.