Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Security at the field level
As far as I know, at least thru v7.3 the, only way to enforce field level security is through the use of views...
Create a view that only contains the fields the user is allowed to see ( or manipulate ) and grant access to the view, not the underlying table...
This way, the user only can access those fields....create separate views for each level of access you want to control....
netcop0101_at_my-dejanews.com wrote:
>All:
>
>I was informed by someone that Oracle supported security or permissions at the
>field level natively. However, everything I can find only addresses setting
>permissions to the table level (i.e. Grant) per user. If you have any
>information on this topic please let me know, or point me to a good reference.
>
>Thanks;
>
>Lori
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 30 1999 - 10:20:58 CDT