| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Security at the field level
A copy of this was sent to netcop0101_at_my-dejanews.com
(if that email address didn't require changing)
On Fri, 30 Apr 1999 14:04:08 GMT, you 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.
>
you can use declaritive grants on columns for insert/update or references (eg: you can grant update on ename to someone -- making is possible to update the ename column of a table but not the empno column for example).
For selects, you would use views to restrict the columns individuals may see.
>Thanks;
>
>Lori
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |