Home > mailing lists

Design Database, 3 degrees of Users. - Mailing list pgsql-general

From	Andre Lopes
Subject	Design Database, 3 degrees of Users.
Date	July 31, 2009 11:38:43
Msg-id	18f98e680907310438o764e9bc7hbb6e245d8464792@mail.gmail.com Whole thread Raw
Responses	Re: Design Database, 3 degrees of Users. Re: Design Database, 3 degrees of Users. Re: Design Database, 3 degrees of Users.
List	pgsql-general

I need to design a Database that will handle 3 degrees of users:

Administrators - They can see all the information in the database.

Managers - They only can see the information of his dependants.

Dependants - Theirs action must be aprovet by the managers.

Wich the best way to implement this in PostGreSQL? There is some database examples doing this? Some OpenSource Project?

I'am designing a Database for doing this, but I don't have sure I'am doing well.

Please give me some advice.

Best Regards,

André Lopes.

From: Jennifer Trey
Date: 31 July 2009, 11:10:34
Subject: Re: Can I have a look at your TuningWizard generated config file?

From: Thom Brown
Date: 31 July 2009, 12:50:07
Subject: MSSQL to PostgreSQL