Re: Design Issue (Employee and Client)



Maybe I should have specified some things. I am using ASP.NET 2.0 and
am creating my own MembershipProvider implementation.

fingermark@xxxxxxxxx wrote:
I am trying to design a login system, but I am running in to a couple
of design issues. All tips are welcome.

There are two principals that need to access the system: employees and
clients. Clients login at clients.example.com. Employees login at
employees.example.com.

First design issue:
1. Description: Currently, I have a Persons table (this contains the
username, password, email, ... of the users). I have a Employees table
that has a foreign key to the Persons table (to PersonID). I have a
Client table that has a foreign key to Persons table (to PersonID).

Issue: Is having the login information for employees and clients in
one table a bad idea? I see no reason why, but I'm just a little
concerned.

2. Description and issue: Once the user is logged in, how can I
prevent clients from accessing employee pages and vice versa? Would I
do this through user profiles? Or would I do this with roles, like
Employee role and Client role. Employees are going to be given roles
anyways, like Billing, Customer Service, Administrator, ...

Thanks

.



Relevant Pages

  • Design Issue (Employee and Client)
    ... I am trying to design a login system, but I am running in to a couple ... Clients login at clients.example.com. ... Employees login at ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: linking data from one table to another
    ... The Clients, Employees and Projects tables (or whatever you choose to call ... The WorkAllocations table, which models the relationship type between the ... shows your logical model is set up correctly. ...
    (microsoft.public.access.gettingstarted)
  • H1B
    ... Our employees work in several skills including Web Technologies, ... Business Analysis and Quality Assurance. ... clients are usually in the Telecom, Banking, Health Care and Insurance ...
    (alt.comp.hardware.pc-homebuilt)
  • Re: Missive from me jollidays
    ... Our employees work in several skills including Web Technologies, ... Business Analysis and Quality Assurance. ... clients are usually in the Telecom, Banking, Health Care and Insurance ...
    (uk.people.silversurfers)
  • Re: VISA
    ... Our employees work in several skills including Web Technologies, ... Business Analysis and Quality Assurance. ... clients are usually in the Telecom, Banking, Health Care and Insurance ...
    (misc.immigration.usa)