From aras_h1988@yahoo.com Sat Nov 20 16:15:08 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5EDE11337B55 for ; Sat, 20 Nov 2010 12:15:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 10161-05 for ; Sat, 20 Nov 2010 16:15:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm14-vm0.bullet.mail.ac4.yahoo.com (nm14-vm0.bullet.mail.ac4.yahoo.com [98.139.52.234]) by mail.postgresql.org (Postfix) with SMTP id C8FE81337999 for ; Sat, 20 Nov 2010 12:15:00 -0400 (AST) Received: from [98.139.52.196] by nm14.bullet.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 16:14:59 -0000 Received: from [98.139.52.185] by tm9.bullet.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 16:14:59 -0000 Received: from [127.0.0.1] by omp1068.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 16:14:59 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 6457.19203.bm@omp1068.mail.ac4.yahoo.com Received: (qmail 26699 invoked by uid 60001); 20 Nov 2010 16:14:58 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1290269698; bh=IvfqEytqssJwAX4z41sS2Z8gQKOP/2fbBlF81iKGf0g=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=QmU8bXuVnMKQSMrjdnhENOqhcRT4l1SNU8nFeVhwZEGYj12Yb0ZNKYICQoN65wQ5/ljvkb4tPfmOSduWJnKiUtdd3/WdoFfxuHgHXkcDn09lKQlih1u9NGCcN6R4VBmjJ10EfvH0vXcML7xwx41FMmkgTsicDGTats7dQfZA+qw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=6FA2rviE3a3Xm2FP2UMkHamrP4uKcl1SM/p6tHYlHGv6pc467yMpNV5TLu53sce2lzYvheaSTKgYnL9Y9PFVwrxV55MI1TtxOhCTwCy9LN6MhUKeus4FEMZe24kLm8NdnZfmO4wijjJF8dLQcJQtgIeaRUCjbpo7LvkH16K0XI8=; Message-ID: <897046.26686.qm@web56001.mail.re3.yahoo.com> X-YMail-OSG: 5l0bD.AVM1kdd.fzDYy7VxacfpG69Q2uqlzs7UG2RmVXkym plxb5JDUWFEsrYIxSVArGk1bxZ2tW7eNhJkoZXdX93gp.oQCHTDbScEiQ9jT lUYM44bfk.YCdmFUswbzuuPuz9uAfNX031L0nDs0zrNNwH2Q7i8exp4FGKUK 7DxBcVmz9.qrrY2D0H1HmXsDsG0fy_4d6JSiTqRJqRJHkI_bm7uAqHJoRRLf 2HsXHdgoPQyhJC4IfCwzwsqIVOkU08ObdZafnossWbAm5sHsZ1PRvA7FjZ1C _ZFTA.ZQdFXgyLBljvCLXX_x9ixVHAtwgVcPZng-- Received: from [46.100.37.111] by web56001.mail.re3.yahoo.com via HTTP; Sat, 20 Nov 2010 08:14:58 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Sat, 20 Nov 2010 08:14:58 -0800 (PST) From: "Pourghorban.S" Subject: implement BLP model on Postgresql db To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1814462495-1290269698=:26686" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.765 tagged_above=-10 required=5 tests=BAYES_50=0.8, DEAR_SOMETHING=1.973, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: ** X-Archive-Number: 201011/156 X-Sequence-Number: 36122 --0-1814462495-1290269698=:26686 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear Sirs, =A0 =A0=A0=A0=A0=0A I have a undergraduate thesis with the title " implementing= a =0Adiscretionary access control model "=A0 on Postgresql based on The Be= ll- =0ALa Padula Model (BLP). =A0=A0=A0 Please let me know how I could start working on my thesis. =A0=A0=A0=A0=20 =A0=A0=A0 I mean, which materials or documents would be useful.=20 =A0=A0=A0=20 Regards,=20 Sara=20 =A0=A0=A0=A0 =0A=0A=0A --0-1814462495-1290269698=:26686 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Dear Sirs,
 
 = ;   =0A I have a undergraduate thesis with the title " imple= menting a =0Adiscretionary access control model "  on Postgresql based= on The Bell- =0ALa Padula Model (BLP).

    Please le= t me know how I could start working on my thesis.
   &nbs= p;
    I mean, which materials or documents would be use= ful.
   

Regards,

Sara

 &nb= sp;  

=0A=0A --0-1814462495-1290269698=:26686-- From robin@edesix.com Thu Dec 2 16:19:07 2010 Received: from wm.hub.org (wm.hub.org [200.46.204.128]) by mail.postgresql.org (Postfix) with ESMTP id 0A7601337B83 for ; Thu, 2 Dec 2010 12:19:07 -0400 (AST) Received: from maia (wm.hub.org [200.46.204.128]) by wm.hub.org (Postfix) with ESMTP id 003B854DC2E8 for ; Thu, 2 Dec 2010 16:19:07 +0000 (UTC) X-Greylist: delayed 00:07:45.6098 by SQLgrey-1.7.6 Received: from woodbine.london.02.net (woodbine.london.02.net [87.194.255.145]) by mail.postgresql.org (Postfix) with ESMTP id 0843913364DE for ; Sat, 20 Nov 2010 14:19:18 -0400 (AST) Received: from lenin.edesix.com (93.97.174.104) by woodbine.london.02.net (8.5.124.10) id 4CCAF07600830A22; Sat, 20 Nov 2010 18:11:29 +0000 Received: from localhost ([127.0.0.1] helo=mail.edesix.com) by lenin.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.72) (envelope-from ) id 1PJruI-0003Nn-BU; Sat, 20 Nov 2010 18:11:28 +0000 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Date: Sat, 20 Nov 2010 18:11:25 +0000 From: robin To: "Pourghorban.S" Cc: Subject: Re: implement BLP model on Postgresql db In-Reply-To: <897046.26686.qm@web56001.mail.re3.yahoo.com> References: <897046.26686.qm@web56001.mail.re3.yahoo.com> Message-ID: <8947ebf975566c44b19d3a771fa48b33@edesix.com> X-Sender: robin@edesix.com User-Agent: RoundCube Webmail/0.3.1 X-Spam-Score: -19.9 (-------------------) X-Spam-Report: lenin.edesix.com has assigned spam score: -19.9 / 5.0 pts rule name description ---- ---------------------- -------------------------------------------------- -20 ALL_TRUSTED Passed through trusted hosts only via SMTP 2.0 DEAR_SOMETHING BODY: Contains 'Dear (something)' -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] X-Archive-Number: 201012/21 X-Sequence-Number: 36250 On Sat, 20 Nov 2010 08:14:58 -0800 (PST), "Pourghorban.S" wrote: > Dear Sirs, >   >      > I have a undergraduate thesis with the title " implementing a > discretionary access control model "  on Postgresql based on The Bell- > La Padula Model (BLP). > >     Please let me know how I could start working on my thesis. >      One would hope _you_ would know that ... else why are you doing it. All the documentation will be on the main postgres site, as is the source code: http://lmgtfy.com/?q=postgres+documentation http://lmgtfy.com/?q=postgres+source+code Hope this helps ... Robin From aras_h1988@yahoo.com Sat Nov 20 19:02:43 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A50861337B7D for ; Sat, 20 Nov 2010 15:02:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 03645-06 for ; Sat, 20 Nov 2010 19:02:28 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm23.bullet.mail.ac4.yahoo.com (nm23.bullet.mail.ac4.yahoo.com [98.139.52.220]) by mail.postgresql.org (Postfix) with SMTP id 015CE1337999 for ; Sat, 20 Nov 2010 15:02:27 -0400 (AST) Received: from [98.139.52.192] by nm23.bullet.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 19:02:26 -0000 Received: from [98.139.52.145] by tm5.bullet.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 19:02:26 -0000 Received: from [127.0.0.1] by omp1028.mail.ac4.yahoo.com with NNFMP; 20 Nov 2010 19:02:26 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 723241.83031.bm@omp1028.mail.ac4.yahoo.com Received: (qmail 36672 invoked by uid 60001); 20 Nov 2010 19:02:26 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1290279746; bh=CczQrKNMZ8/2Dp4syxP49kXvPRIJO9JC94uo89lZK7s=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=eoXv+3kkHWhMRbf/8W+5xYpLbMedwzOn1Exy/u6Q3g7CeHuwjVRAaTCQD6b8o/KejIodyaD69P/UMuBFK0UChU5N0sq0W61FGDYW4E7Hx3+/r8McyfdYwBFvCvqetSqSy4At/lwTRwOyCxObPezsbdVsaD+QfFpu8BUZ5MJJ2Fw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=u2TPQ5d7PNpEZ3y9YQH2QLgZx19DaT1wSwJyq4m+Oppa2IngxP4dR6h9gnxz9F25sdfZNRCdURledyHi8ctU+8v7V35Cprrt6/XgYep8LyRcHdd2gj4EbYCHmk3+B6gGaGvSPrKYBkhGMYzufdtkKBhU6aJ6+J5SwPnWfOtwhBg=; Message-ID: <606711.36098.qm@web56003.mail.re3.yahoo.com> X-YMail-OSG: we9JzCgVM1kz2R5LPYl8WpspD6t1UiEDupNVFgBe4USk8xI EFscb0o5gXqaF_AoV3oeBbO5Yd5AG3pUrlFW2X9WnBU4h4j2w2hy..uddo_4 1aZZdPyX_BX56A811WA48rjhJdnQ8UhAIISwDfr8C691691qahU1zslTYE8Q xomKyhac7TU01mQ6vR7pwB3qSaJ2QMMN_X7A2g8V0BzK.UDHVXJ_g4IjD5FW ZWWwYLceQUKgzv7EbxfJSIlA8bD80ChBs1Z6OQedlC3jBYlcEuoqVXPU682p 3VUqNwWsGooqofjbvTpFD5F.zwfcsfys9AU9uG7LFwrnfjU0bUUtNRLXDqtA qvMPOiHKEETTzONZQtg-- Received: from [46.100.37.111] by web56003.mail.re3.yahoo.com via HTTP; Sat, 20 Nov 2010 11:02:26 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Sat, 20 Nov 2010 11:02:26 -0800 (PST) From: "Pourghorban.S" Subject: Re: implement BLP model on Postgresql db To: admin In-Reply-To: <8947ebf975566c44b19d3a771fa48b33@edesix.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2111790284-1290279746=:36098" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.065 tagged_above=-10 required=5 tests=BAYES_00=-1.9, DEAR_SOMETHING=1.973, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/157 X-Sequence-Number: 36123 --0-2111790284-1290279746=:36098 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I mean that what should I do?=20 For implement BLP model on postgresql? Sara=20 --- On Sat, 11/20/10, robin wrote: From: robin Subject: Re: [ADMIN] implement BLP model on Postgresql db To: "Pourghorban.S" Cc: pgsql-admin@postgresql.org Date: Saturday, November 20, 2010, 9:41 PM On Sat, 20 Nov 2010 08:14:58 -0800 (PST), "Pourghorban.S" wrote: > Dear Sirs, > =A0 > =A0=A0=A0=A0 >=A0 I have a undergraduate thesis with the title " implementing a=20 > discretionary access control model "=A0 on Postgresql based on The Bell-= =20 > La Padula Model (BLP). >=20 > =A0=A0=A0 Please let me know how I could start working on my thesis. > =A0=A0=A0=A0=20 One would hope _you_ would know that ... else why are you doing it.=20 All the documentation will be on the main postgres site, as is the source code: http://lmgtfy.com/?q=3Dpostgres+documentation http://lmgtfy.com/?q=3Dpostgres+source+code Hope this helps ... Robin =0A=0A=0A --0-2111790284-1290279746=:36098 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable <= /tr>

I mean that what should I do?
For imp= lement BLP model on postgresql?
Sara

--- On Sat, 11/20/10, ro= bin <robin@edesix.com> wrote:
=
From: robin <robin@edesix.com>
Subject: Re: [ADMIN] implement = BLP model on Postgresql db
To: "Pourghorban.S" <aras_h1988@yahoo.com&= gt;
Cc: pgsql-admin@postgresql.org
Date: Saturday, November 20, 2010,= 9:41 PM

On Sat, 20 Nov 2010 08:14:58 -0800= (PST), "Pourghorban.S"
<aras_h1988@yahoo.com> = wrote:
> Dear Sirs,
>  
>     >  I have a undergraduate thesis with the title " implementing a =
> discretionary access control model "  on Postgresql based on The Bell= -
> La Padula Model (BLP).
>
>     Pleas= e let me know how I could start working on my thesis.
>   &= nbsp; 
One would hope _you_ would know that ... else why are you d= oing it.
<sigh>

All the documentation will be on the main = postgres site, as is the source
code:

http://lmgtfy.com/?q=3Dpos= tgres+documentation

http://lmgtfy.com/?q=3Dpostgres+source+code

Hope this helps ...

Robin


=0A=0A --0-2111790284-1290279746=:36098-- From aras_h1988@yahoo.com Sun Nov 21 08:41:56 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 916F41337B5E for ; Sun, 21 Nov 2010 04:41:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 21069-08 for ; Sun, 21 Nov 2010 08:41:50 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm19-vm0.bullet.mail.ac4.yahoo.com (nm19-vm0.bullet.mail.ac4.yahoo.com [98.139.53.212]) by mail.postgresql.org (Postfix) with SMTP id E09331337B58 for ; Sun, 21 Nov 2010 04:41:48 -0400 (AST) Received: from [98.139.52.189] by nm19.bullet.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 08:41:46 -0000 Received: from [98.139.52.171] by tm2.bullet.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 08:41:46 -0000 Received: from [127.0.0.1] by omp1054.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 08:41:46 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 692649.71098.bm@omp1054.mail.ac4.yahoo.com Received: (qmail 14174 invoked by uid 60001); 21 Nov 2010 08:41:46 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1290328906; bh=pNaGvINCTRTkfpIcu7Q+CNU/dzB9GYF1J8KiKOZKvc4=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=1e0dH73ta28FDzEZASqEWH+t6rcYykkPkVz4p+9V2ugCQnjomYvs8e02MEJ8Qm81IL7Fdps4Zfmd6OFA+asWONSCHLoUWPKz90ReLV3x5zEO3YN8Tp2Hml+VYUVSn2gn7N0rOTYKkWPDD9anq0tidEHasO1QcyCru6Cn5wJcuI0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=2+GFZVrc+f4hrfTk8rqTgg2hN3fYg2HcrCa5rOiXWk2sUjQ0mabQ1MEV0ZK4Pgo2eEWL2KX6P3s4hEZykFoxrN5PjDK4VaFCUbuCiobPRzjHFhC3jgeEWD9xuKA46azajvi2PJaSnasW1xwnwUWhli1KV9RW3ns5uLmWAH0Ie44=; Message-ID: <398458.12164.qm@web56003.mail.re3.yahoo.com> X-YMail-OSG: e5JVD0gVM1lKWtJjsKLzjC.z_WEuDHWy8NWpPI2WFZxQ2i3 fZlJ.bQDvTykF_mb_IA8C50huZXgt8zKGSu5s_KvU.Px.vWd37BwMi5GPYG2 MZ6txUdMcxjll6o5cG3aj3WvDQ8gnd_1l5E9lTB79owXN0WXU7YcGvTFQlRR IFn9PxJrz8F.FZi4.Z4MYLNiJQ4aUg6bI4GIdXN0eg1OcSA_6h0Ub8YCFYwQ 3xJzs.vC7sSdmcaZIxulMpl0Q.7yVLJC26B965rtTIog.Cc4SnM04wZ1g7y5 0uF_1shXTDgjHMla5CzIREmnxVg2tDc7YocEK5rrfjbYoX4x79_tCsW86FO9 v8pNusFn.szNacjHz7r7zjkugLPaR9aApLFPs_OWD2GStCA-- Received: from [78.39.190.253] by web56003.mail.re3.yahoo.com via HTTP; Sun, 21 Nov 2010 00:41:45 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Sun, 21 Nov 2010 00:41:45 -0800 (PST) From: "Pourghorban.S" Subject: Re: implement BLP model on Postgresql db To: Cliff Pratt Cc: admin In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-472749117-1290328905=:12164" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.065 tagged_above=-10 required=5 tests=BAYES_00=-1.9, DEAR_SOMETHING=1.973, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/158 X-Sequence-Number: 36124 --0-472749117-1290328905=:12164 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable yes I know the method for implement, but I do=A0 not know where I should im= plement necessary changes .... I know that I should add a additional column in my data base tables that sh= ow the level of access of each row.=20 these level types is finite.=20 and by the way I should add to a sql command which user issues, the conditi= on that it checks whether he / she can access / gain the row he/ she want o= r not.=20 But I don't know these two steps how and where I should implement. Regards, =A0 --- On Sun, 11/21/10, Cliff Pratt wrote: From: Cliff Pratt Subject: Re: [ADMIN] implement BLP model on Postgresql db To: "Pourghorban.S" Date: Sunday, November 21, 2010, 2:07 AM On Sun, Nov 21, 2010 at 5:14 AM, Pourghorban.S wrote= : > > Dear Sirs, > > =A0=A0=A0=A0 I have a undergraduate thesis with the title " implementing = a > discretionary access control model "=A0 on Postgresql based on > The Bell- La Padula Model (BLP). > > =A0=A0=A0 Please let me know how I could start working on my thesis. > > =A0=A0=A0 I mean, which materials or documents would be useful. > Have you research the BLP model? That's what I would do first. Google it. However even before that you should discuss this with your supervisor, who no doubt has something in mind and can and should give you references to follow. Cheers, Cliff =0A=0A=0A --0-472749117-1290328905=:12164 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
=0A=0A --0-472749117-1290328905=:12164-- From scott_ribe@elevated-dev.com Sun Nov 21 15:36:45 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C3F1A1337B80 for ; Sun, 21 Nov 2010 11:36:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 98374-05 for ; Sun, 21 Nov 2010 15:36:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.sea5.speakeasy.net (mail1.sea5.speakeasy.net [69.17.117.39]) by mail.postgresql.org (Postfix) with ESMTP id 3F15B1337B5E for ; Sun, 21 Nov 2010 11:36:37 -0400 (AST) Received: (qmail 29623 invoked from network); 21 Nov 2010 15:36:36 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (scott_ribe@killerbytes.com@[72.42.76.25]) (envelope-sender ) by mail1.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 21 Nov 2010 15:36:36 -0000 Subject: Re: implement BLP model on Postgresql db Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: <398458.12164.qm@web56003.mail.re3.yahoo.com> Date: Sun, 21 Nov 2010 08:36:33 -0700 Cc: admin Content-Transfer-Encoding: quoted-printable Message-Id: <418F58E7-A0B5-4F37-A5BB-8E2D0E3B4CBE@elevated-dev.com> References: <398458.12164.qm@web56003.mail.re3.yahoo.com> To: "Pourghorban.S" X-Mailer: Apple Mail (2.1081) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/160 X-Sequence-Number: 36126 On Nov 21, 2010, at 1:41 AM, Pourghorban.S wrote: > yes I know the method for implement, but I do not know where I should = implement necessary changes .... > I know that I should add a additional column in my data base tables = that show the level of access of each row.=20 > these level types is finite.=20 > and by the way I should add to a sql command which user issues, the = condition that it checks whether he / she can access / gain the row he/ = she want or not.=20 > But I don't know these two steps how and where I should implement. Now at least you're giving us questions of "how do I do this in a = database", rather than asking about how to write a thesis on a subject = very few (if any) of us know about. That's progress ;-) So you want to add a column to a table: You might want to create an enum type for the access level and use that = as the column type: How the command should work is rather vague, you might want to create a = stored function to evaluate access: But that would depend on some enforcement in an application or = middleware. A function that just checks access is not enough, you have = to enforce it. And that is a more substantial project. You might be able = to use rules. You might want to use view whose statements use = current_user(). If you have a lot of pre-existing tables to which the access info must = be added, you might want to use dynamic sql to automate adding that = column. But, given that "I should add a additional column in my data base tables = that show the level of access of each row" seemed to be giving you = trouble, you might want to first read an introductory book on SQL. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice From Kevin.Grittner@wicourts.gov Sun Nov 21 15:54:30 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4AB891337B2F for ; Sun, 21 Nov 2010 11:54:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 40336-03 for ; Sun, 21 Nov 2010 15:54:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 068BC1337B58 for ; Sun, 21 Nov 2010 11:54:22 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Sun, 21 Nov 2010 09:54:23 -0600 Message-Id: <4CE8EC480200002500037C95@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Sun, 21 Nov 2010 09:54:16 -0600 From: "Kevin Grittner" To: , Cc: Subject: Re: implement BLP model on Postgresql db Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/161 X-Sequence-Number: 36127 "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 aras_h1988@yahoo.com Sun Nov 21 18:07:41 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2C1721335B36 for ; Sun, 21 Nov 2010 14:07:41 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 16840-06 for ; Sun, 21 Nov 2010 18:07:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm28.bullet.mail.ac4.yahoo.com (nm28.bullet.mail.ac4.yahoo.com [98.139.52.225]) by mail.postgresql.org (Postfix) with SMTP id 2C7851337B58 for ; Sun, 21 Nov 2010 14:07:33 -0400 (AST) Received: from [98.139.52.196] by nm28.bullet.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 18:07:32 -0000 Received: from [98.139.52.168] by tm9.bullet.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 18:07:32 -0000 Received: from [127.0.0.1] by omp1051.mail.ac4.yahoo.com with NNFMP; 21 Nov 2010 18:07:32 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 530044.31867.bm@omp1051.mail.ac4.yahoo.com Received: (qmail 99675 invoked by uid 60001); 21 Nov 2010 18:07:32 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1290362852; bh=qkvzXNJn+jWnroBOnXTqn4MjzmOf5vmO5xlQcjfpj8Q=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=ydgimYkekkS/ho9fbSEurAnosyE/651pR8ZyokchTUPKsOeD77tatjuZsNmuOn6ASC8bXk+3G+mGhqb4LgXA9g+qCinBDDvjpXSEV2BeKlCqR/tdB2YroCAFsF4YJ2vJJT6yYc/+xRkUEaO4yCJdQIwl2sixjLF3tP0YRZ2lgI0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=WPWRMW4ItGfH/DkYI7VX41C4pBJ+LIbRCu3D642A9AO6ZmUuRJZA5JUI/278qQ+0eypG5QPxRaszqqbIbqJhYjQt3m6w65Wk4Boo29FIY00BtDAaqc3hpb/9/VVKoOeBk5KrD6K8+b0jD8X97AoVGmGXRaKaZsBFJQw5KBQrsI4=; Message-ID: <360809.99388.qm@web56006.mail.re3.yahoo.com> X-YMail-OSG: pcynkOYVM1lmL6NrwlqwJwlsPD1kqHwNVG0D44L4DI77n_o B1emQ2Lt2UgqLY0fDM4f84BYPIE_BkFg.KaW_1YIEx53gGRcQDar3wT2OT1M guKfAiROWgRb6s66UIH01VikFuDNjPN3GUYkxKoIxqGFzheaQfFDdVapfT9s 0JxyDzTrzphuyWjrDgmX0YYDIpMp5N8eg.ZCzdRs23OgWyV83ssiaBLcQHSU .nhfS3BjXqcJiVX_6cR6cmrFlbUW1GSBB.RvfSCAOvHGdGvL.OPMq8YaOzXo q6hB9MmQd7Nawwief9_I2CqYQPs7DlXwleuxwbVuPiZ05juO5HVqMKtHx1tj acFmt4yE8gZu5H8otyA-- Received: from [78.39.190.253] by web56006.mail.re3.yahoo.com via HTTP; Sun, 21 Nov 2010 10:07:32 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Sun, 21 Nov 2010 10:07:32 -0800 (PST) From: "Pourghorban.S" Subject: Re: implement BLP model on Postgresql db To: Scott Ribe Cc: admin In-Reply-To: <418F58E7-A0B5-4F37-A5BB-8E2D0E3B4CBE@elevated-dev.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1436626114-1290362852=:99388" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/163 X-Sequence-Number: 36129 --0-1436626114-1290362852=:99388 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear Scott,=20 Thank you very much for your answer. But my supervisor told me that I shoul= d add an extra column for all rows in my tables that show the level of acce= ss of each row, when a user gives a query.=20 Before I saw this link : http://www.centos.org/docs/5/html/Deployment_Guide-en-US/sec-mls-ov.html yes the important is, what considerations should I attention and which capa= bilities. And I know abstractly about BLP model, SQL, and Database.=20 Sara --- On Sun, 11/21/10, Scott Ribe wrote: From: Scott Ribe Subject: Re: [ADMIN] implement BLP model on Postgresql db To: "Pourghorban.S" Cc: "admin" Date: Sunday, November 21, 2010, 7:06 PM On Nov 21, 2010, at 1:41 AM, Pourghorban.S wrote: > yes I know the method for implement, but I do=A0 not know where I should = implement necessary changes .... > I know that I should add a additional column in my data base tables that = show the level of access of each row.=20 > these level types is finite.=20 > and by the way I should add to a sql command which user issues, the condi= tion that it checks whether he / she can access / gain the row he/ she want= or not.=20 > But I don't know these two steps how and where I should implement. Now at least you're giving us questions of "how do I do this in a database"= , rather than asking about how to write a thesis on a subject very few (if = any) of us know about. That's progress ;-) So you want to add a column to a table: You might want to create an enum type for the access level and use that as = the column type: How the command should work is rather vague, you might want to create a sto= red function to evaluate access: But that would depend on some enforcement in an application or middleware. = A function that just checks access is not enough, you have to enforce it. A= nd that is a more substantial project. You might be able to use rules. You = might want to use view whose statements use current_user(). If you have a lot of pre-existing tables to which the access info must be a= dded, you might want to use dynamic sql to automate adding that column. But, given that "I should add a additional column in my data base tables th= at show the level of access of each row" seemed to be giving you trouble, y= ou might want to first read an introductory book on SQL. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin =0A=0A=0A --0-1436626114-1290362852=:99388 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
yes I know the method for implement, but I do=   not know where I should implement necessary changes ....
I know t= hat I should add a additional column in my data base tables that show the l= evel of access of each row.
these level types is finite.
and by the= way I should add to a sql command which user issues, the condition that it= checks whether he / she can access / gain the row he/ she want or not. But I don't know these two steps how and where I should implement.

= Regards,

 

--- On Sun, 11/21/10, Cliff Pratt <e= nkiduonthenet@gmail.com> wrote:

= From: Cliff Pratt <enkiduonthenet@gmail.com>
Subject: Re: [ADMIN] = implement BLP model on Postgresql db
To: "Pourghorban.S" <aras_h1988@yahoo.com>
Date: Sunday, November 21, 2010, 2:07 AM
On Sun, Nov 21, 2010 at 5:14 AM, Pourghorban= .S <aras_h1988@yahoo.com> wrote:
>
> D= ear Sirs,
>
>      I have a undergraduate t= hesis with the title " implementing a
> discretionary access control = model "  on Postgresql based on
> The Bell- La Padula Model (BLP= ).
>
>     Please let me know how I could start = working on my thesis.
>
>     I mean, which mate= rials or documents would be useful.
>
Have you research the BLP mo= del? That's what I would do first. Google it.

However even before th= at you should discuss this with your supervisor,
who no doubt has someth= ing in mind and can and should give you
references to follow.

Cheers,

Cliff

Dear Scott,
Thank you very much for y= our answer. But my supervisor told me that I should add an extra column for= all rows in my tables that show the level of access of each row, when a us= er gives a query.
Before I saw this link :
http://www.centos.org/doc= s/5/html/Deployment_Guide-en-US/sec-mls-ov.html

yes the important is= , what considerations should I attention and which capabilities.


And I know abstractly about BLP model, SQL, and Database.


=
Sara


--- On Sun, 11/21/10, Scott Ribe <scott_ribe@e= levated-dev.com> wrote:

From: Sc= ott Ribe <scott_ribe@elevated-dev.com>
Subject: Re: [ADMIN] implem= ent BLP model on Postgresql db
To: "Pourghorban.S" <aras_h1988@yahoo.com>
Cc: "admin" <pgsql-admin@postgresql.org= >
Date: Sunday, November 21, 2010, 7:06 PM

On Nov 21, 2010, at 1:41 AM, Pourghorban.S wrote:

> yes I k= now the method for implement, but I do  not know where I should implem= ent necessary changes ....
> I know that I should add a additional co= lumn in my data base tables that show the level of access of each row.
= > these level types is finite.
> and by the way I should add to a= sql command which user issues, the condition that it checks whether he / s= he can access / gain the row he/ she want or not.
> But I don't know= these two steps how and where I should implement.

Now at least you'= re giving us questions of "how do I do this in a database", rather than ask= ing about how to write a thesis on a subject very few (if any) of us know a= bout. That's progress ;-)

So you want to add a column to a table:

<http://www.postgresql.org/docs/9.0/stat= ic/sql-altertable.html>

You might want to create an enum type= for the access level and use that as the column type:

<http://www.postgresql.org/docs/9.0/static/sql-createtype.html>

How the command should work is rather vague, you might want t= o create a stored function to evaluate access:

<
http://www.postgresql.org/docs/9.0/static/sql-createfunction.html&g= t;
<http://www.postgresql.org/docs/9.0/static/plpgsql.html<= /a>>

But that would depend on some enforcement in an application = or middleware. A function that just checks access is not enough, you have to = enforce it. And that is a more substantial project. You might be able to us= e rules. You might want to use view whose statements use current_user().
<
http://www.postgresql.org/docs/9.0/static/sql-cre= aterule.html>
<http://www.postgresql.org/docs= /9.0/static/sql-createview.html>
<http://www.= postgresql.org/docs/9.0/static/functions-info.html>

If you ha= ve a lot of pre-existing tables to which the access info must be added, you= might want to use dynamic sql to automate adding that column.

But, = given that "I should add a additional column in my data base tables that sh= ow the level of access of each row" seemed to be giving you trouble, you migh= t want to first read an introductory book on SQL.

--
Scott Ribe<= br>scott_ribe@elevated-dev.com
http://www.elevated-dev= .com/
(303) 722-0567 voice





--
Sent via pg= sql-admin mailing list (pgsql-admin@postgresql.o= rg)
To make changes to your subscription:
http://www.postgresql= .org/mailpref/pgsql-admin

= =0A=0A --0-1436626114-1290362852=:99388-- From richard.broersma@gmail.com Mon Nov 22 17:03:12 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D2ED61337B89 for ; Mon, 22 Nov 2010 13:03:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 62238-03 for ; Mon, 22 Nov 2010 17:03:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com [209.85.161.46]) by mail.postgresql.org (Postfix) with ESMTP id CC65A1337B8E for ; Mon, 22 Nov 2010 13:03:04 -0400 (AST) Received: by fxm13 with SMTP id 13so2824597fxm.19 for ; Mon, 22 Nov 2010 09:03:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=eDGfSMcLLh3hEwcH2RCEobTK4ieNxPTX/fZIhhZ1knI=; b=IaeBuc6RtpB/zGwz4rTHLEzWUCbAx5YH/TOCoSNnQFRMc2dex2qVsIJXB/XhwgeiFZ qdiqogOFq5mI1GguYorclKxZDPTQ4TWufy7nGrrK1rxr4MD/qcEvvF0HYUBQrKPBjLof LUh3DSH5E0OZIek6djDy4O71qFYD9zZ8MgJog= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=fuiHdm2KEUx9VfXUoUlifgO8KF5bNRkJzQ0gDvjXUJs8kU9cez+wH2xMOoTnLWCeEg 0TDuXcCpVTJ8m07KL+njKO3/YcnmviznCOMHW6Ja7PyZYMeRQjd/PQKcYRWsdVAOYPe/ 5aQFoLyJeF3cF3W0YwY9zWFuZ/xkcs7pzkMNc= MIME-Version: 1.0 Received: by 10.223.97.13 with SMTP id j13mr4477146fan.146.1290445383491; Mon, 22 Nov 2010 09:03:03 -0800 (PST) Received: by 10.223.83.134 with HTTP; Mon, 22 Nov 2010 09:03:03 -0800 (PST) In-Reply-To: <360809.99388.qm@web56006.mail.re3.yahoo.com> References: <418F58E7-A0B5-4F37-A5BB-8E2D0E3B4CBE@elevated-dev.com> <360809.99388.qm@web56006.mail.re3.yahoo.com> Date: Mon, 22 Nov 2010 09:03:03 -0800 Message-ID: Subject: Re: implement BLP model on Postgresql db From: Richard Broersma To: "Pourghorban.S" Cc: Scott Ribe , admin Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/191 X-Sequence-Number: 36157 On 11/21/10, Pourghorban.S wrote: If your looking to add fine grained access control that is enforcable at the DB level, I'd look into the following project: http://wiki.postgresql.org/wiki/SEPostgreSQL (I don't that this project is ready for production use however.) Also this links might be useful: http://it.toolbox.com/blogs/database-soup/thinking-about-row-level-security-part-1-30732 http://it.toolbox.com/blogs/database-soup/thinking-about-row-level-security-part-2-30757 http://pgexperts.com/document.html?id=39 http://momjian.us/main/writings/pgsql/securing.pdf -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug