Re: Q: Column Level Security

From: William <William_at_hope.demon.co.uk>
Date: Sat, 11 Mar 1995 23:00:43 +0000
Message-ID: <794962843snz_at_hope.demon.co.uk>


In article <3jnq7i$lv7_at_nic.dot.state.mn.us>

           john.greco_at_dot.state.mn.us "John_Greco" writes:

> jwingram_at_whale.st.usm.edu (Jonathan Wayne Ingram) wrote:
> >
> > jpadilla_at_epix.net wrote:
> >
> > : Hola!
 

> > : I am working in a application in which we need to be able to enforce column > > : level security dynamically. What I mean by dynamically is that we will be
> > : having a pool of modules that we need to assign to users depending on the
> > : user position, etc.
> >
> > Jonathan
> > jwingram_at_whale.st.usm.edu
>
> The way I use to limit access on a column level is to
>
> create views that contain only the columns you want the
>
> user to see .... grant the user access ONLY to the view, not
>
> the underlying table and the access is limited.
>
> Hope it helps :)
>
> John Greco
> Oracle DBA ( 7.0.16.., Netware )
>
>
>
>

Jonathan,

Perhaps you can grant update access on a column level basis.

William Received on Sun Mar 12 1995 - 00:00:43 CET

Original text of this message