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)
  • Re: Abnormal Normalization?
    ... some easy questions - and mostly read a lot and learn a whole bunch. ... > of the employees end up contracting the company itself to do remodeling or ... > separate jobs from clients because a client can contract for more than one ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Abnormal Normalization?
    ... of the employees end up contracting the company itself to do remodeling or ... and I had to separate contacts from clients because many clients could ... > I took people's names out of my Employees and Contacts tables, ...
    (microsoft.public.access.tablesdbdesign)
  • Is there a tool that would allow clients to browse (directory listing style) and upload content to a
    ... We have several clients and ... I'd like to give our employees the ability to ... >via a Web based interface). ...
    (microsoft.public.inetserver.iis)