Re: Column Redaction - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Column Redaction
Date
Msg-id CA+U5nM+6xjj3gG---kqUyvQQKBmZ85F3H_b6Pp3DOM3qyy_-bQ@mail.gmail.com
Whole thread Raw
In response to Re: Column Redaction  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: Column Redaction
List pgsql-hackers
On 10 October 2014 11:27, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:

> I googled for Oracle Data redaction, and found "General Usage guidelines":
>
>> General Usage Guidelines
>>
>> * Oracle Data Redaction is not intended to protect against attacks by
>> privileged database users who run ad hoc queries directly against the
>> database.
>>
>> * Oracle Data Redaction is not intended to protect against users who
>> run exhaustive SQL queries that attempt to determine the actual
>> values by inference.
>
>
> So it's not actually suitable for the example you gave. I don't think we
> want this feature...

The full quote I read is the following...

"Even though Oracle Data Redaction is not intended to protect against
attacks by database users who run ad hoc queries directly against the
database, it can hide sensitive data for these ad hoc query scenarios
when you couple it with other preventive and detective controls."

That full context would have been useful.



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: jsonb contains behaviour weirdness
Next
From: Peter Eisentraut
Date:
Subject: Re: orangutan seizes up during isolation-check