 Column Masking for various levels of users [message #142110] |
Thu, 13 October 2005 08:54  |
anilhyd
Messages: 10
Registered: October 2005
|
Junior Member |
|
|
Hi,
Would like to know the options available in Oracle for masking the column display for various users in various levels. The following example explains the same :-
We have a table T1 and it has three columns - c1,c2,c3,c4
User1 should be able to see c1,c2 (level 1 user)
User2 should be able to see c1,c2,c3 (level 2 user)
User3 should be able to see c1,c2,c3,c4 (level 3 user)
All users shall run the same query "Select * from T1" but they should get different output based on their levels.
Can this be implemented using DBMS_RLS (as dbms_rls deals more about row level and column level security. Is there only column masking available in dbms_rsl. If yes are there any examples on implementation.)
Thanks in Advance
Anil..
|
|
|
|
|
|
| Re: Column Masking for various levels of users [message #142118 is a reply to message #142115] |
Thu, 13 October 2005 09:03  |
anilhyd
Messages: 10
Registered: October 2005
|
Junior Member |
|
|
Thanks for the quick response. We are planning to implement using views. But due some problem in reporting tools/existing queries, would like to find out is there any other oracle provided utility (other than view creation).
There is no row level security and only column level masking. Hence would like whether it is possible through dbms_rls and if yes, what is the process.
Regards
Anil..
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
