| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <enkiduonthenet(at)gmail(dot)com>,<aras_h1988(at)yahoo(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: implement BLP model on Postgresql db |
| Date: | 2010-11-21 15:54:16 |
| Message-ID: | 4CE8EC480200002500037C95@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Pourghorban.S" wrote:
> I know that I should add a additional column in my data base tables
> that show the level of access of each row. these level types is
> finite.
You need to spend some time with the documentation:
http://www.postgresql.org/docs/current/interactive/index.html
You might want to pay particular attention to table inheritance and
the roles system available in PostgreSQL. If each security level
inherits from the next level up, you might be able to grant
permissions to appropriate roles at each level to achieve what you
need.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-11-21 16:35:32 | Re: ERROR: could not open relation with OID |
| Previous Message | Scott Ribe | 2010-11-21 15:36:33 | Re: implement BLP model on Postgresql db |