Column Access
- From: "Burton, Laura" <BurtonL@xxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Mar 2005 13:36:41 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
