This content has been marked as final. Show 3 replies
To achieve this you have to introduce two schemas: One that own table (a_owner) and one that will use table with hidden column (a_user).
As an A_OWNER
create table t1 (c1 varchar2(1), c2 varchar2(10));With code above user "a_user" can select c1 but not c2 in table t1.
create public synonym t1 for owner.t1;
grant select, update (c1) on t1 to a_user;
Also he can update c1 but not c2....
If you want to hide the whole t1 then do no grant any privilege as in example before.
Hope this helps,