Re: Column Access

Hi,

This can be done with fine grained access control, available from 8i. Look 
at dbms_rls package...
Otherwise it could be done with separate views as well...

Tanel.

----- Original Message ----- 
From: "Burton, Laura" <BurtonL@xxxxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 11, 2005 2:36 PM
Subject: Column Access


>
> I have read where you can grant access to a column to a user/role.  I
> need to take it one step further.  I need to restrict access to the
> column if it is for a certain group of people.  i.e. I have supervisors
> and mechanics.  Everyone can look at the salary column, except that
> mechanics can only look at mechanics, but supervisors can look at
> everyone.  Can this be done with grants?  The alternative is two
> separate databases and that seems extreme.  If not with a grant is there
> a better way?

--
http://www.freelists.org/webpage/oracle-l

Other related posts: