Re: implement BLP model on Postgresql db - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: implement BLP model on Postgresql db
Date
Msg-id 4CE8EC480200002500037C95@gw.wicourts.gov
Whole thread Raw
In response to implement BLP model on Postgresql db  ("Pourghorban.S" <aras_h1988@yahoo.com>)
List 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

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: implement BLP model on Postgresql db
Next
From: "Kevin Grittner"
Date:
Subject: Re: ERROR: could not open relation with OID