Re: Column Access

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 11 Mar 2005 16:16:14 -0500


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...


----- 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?


Other related posts: