This content has been marked as final. Show 3 replies
I don't know what does it mean hiding ??
Do you need hiding on other user or what.
Simple solution for hiding column is create view on table.
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,
Could you be so kind and mark this topic as answered?