RE: Column Access

From: Vlado Barun <vlado_at_cadre5.com>
Date: Fri, 11 Mar 2005 16:30:33 -0500
Message-Id: <200503112130.j2BLUf171494@cadre5.com>

At least two options:
1) You could create a view for the mechanics which only returns the data that they are allowed to access. Grant them access to that view, and revoke access to the table.

2) Check out Oracle fine-grained access control. Haven't used it, but from what I understand it should do what you need...

Vlado Barun, M.Sc.
Mobile: 865 335 7652
AIM: vbarun2

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura
Sent: Friday, March 11, 2005 2:37 PM
To: Oracle-L Freelists
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?

=20

Thank you,

Laura

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 11 2005 - 16:52:07 CST