Re: Views and confidentiality

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Reshat Sabiq <sabiq(at)purdue(dot)edu>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Views and confidentiality
Date: 2003-09-27 20:24:42
Message-ID: 200309271324.42151.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Reshat,

> In my opinion, access permissions and views (data preprocessing, etc.)
> both represent a mechanism to increase confidentiality of data. There's
> a person who doesn't think so. Who do you think is right?

Who doesn't think so?

> P.P.S. I believe we can create arbitrary views, including views that
> aggregrate data from many rows into a summary value. Please correct me
> if i'm wrong.

Yes, you can.

For that matter, Neil and I were talking about automated building of update
rules for simple views, meaning that in the future simple "confidentiality"
views would also be updatable without you having to figure out the RULES
system.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Doris Bernloehr 2003-09-28 13:11:46 SQL Syntax problem
Previous Message Reshat Sabiq 2003-09-27 19:38:27 Views and confidentiality