Design Issue (Employee and Client)



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

  • Re: Design Issue (Employee and Client)
    ... Clients login at clients.example.com. ... Employees login at ... First design issue: ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Clients - internal and external, how design and process?
    ... "Internal clients are employees who are ... Tremors II ... Embedding "hidden" information in a field is not good design practice as ...
    (microsoft.public.access.tablesdbdesign)
  • 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)
  • Re: AT&T WiFi at McDonalds, etc
    ... encrypted with a unique one time WPA key delivered by a RADIUS server, ... All current wireless clients auto detect the method of authentication, ... and supply a corresponding dialog box for login if required. ... What part of the WPA-RADIUS login process doesn't work the way I ...
    (alt.internet.wireless)
  • Group Policy Wont update on client
    ... Windows 2k3 AD as secondary login,all passwords synced with Novell ... Our issue was after a recent change to a GPO, no clients would receive updated GPOs. ...
    (microsoft.public.windows.group_policy)