i need some guide about how to hiding table or column on oracle?
i am already read about vpd and data vault, but i only common user, and that's technique just only for dba, so i can't do it
anyone can help ? thx for all
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));
create public synonym t1 for owner.t1;
grant select, update (c1) on t1 to a_user;
With code above user "a_user" can select c1 but not c2 in table t1.
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,