db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Workaround of 'grant' or hiding columns
Date Wed, 30 Aug 2006 05:24:03 GMT
Peter, support for grant/revoke is targeted for upcoming 10.2 release.

Mamta


On 8/29/06, Peter Karich <peathal@yahoo.de> wrote:
>
> Hi,
>
> I walked through all documentation and some forum posts.
> And I figured out that there is no support for granting privileges on
> select, update etc.
> Now my questions are:
>
> 1. Which release will support grant?
> 2. Is there a dev-version that already supports grant?
> 3. Is there a common workaround (on grant AND revoke)?
> 4. Is there a special workaround for this situation:
>
> I have a table Person with two columns: secureCol and publicCol.
> And I want that only some users, can do
>
> select * from Person -- result: secureCol, publicCol
>
> And untrusted users (e.g. U1,U2,...) will get only publicCol.
> I tried it with 'creating a view' for every untrusted-person:
>
> create view APP.Person as select publicCol from U1.Person
>
> But this does not work, because user U1 can do
> set schema APP
> and he gets full access on the Person-table.
>
> Please, can you help me? This would help me and my opensource project!
>
> -peter
>
>
> ___________________________________________________________
> Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
>

Mime
View raw message