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_at_frmaint.com>
To: "Oracle-L Freelists" <oracle-l_at_freelists.org>
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
Received on Fri Mar 11 2005 - 16:47:45 CST
