Re: Reject access to a single record

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 25 Mar 2003 07:12:42 -0800
Message-ID: <1a8fec49.0303250712.4cfa7494_at_posting.google.com>


This is only available with Enterprise Edition (very annoyingly) so do not plan on using it with Standard Edition.

You can get a similar effect with public views of private tables if you are careful.

ETA JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0303240927.1795af71_at_posting.google.com>...
> Look up Fine Grained Access Control (FGAC).
>
>
> - Jusung Yang
>
>
> Miko_at_boehrer.de (Ralf) wrote in message news:<fa624200.0303240649.4c2852e1_at_posting.google.com>...
> > Hi to all,
> >
> > has Oracle the ability to reject or grant access
> > (read (=select), write (=update) or delete)
> > to one single record for an user.
> > That means for example this specific user is allowed to update the
> > address-record: "Smith" but not the address-record: "Adams".
> >
> > Thanks in advance for any help or comment.
> > Ralf
Received on Tue Mar 25 2003 - 16:12:42 CET

Original text of this message