Hi Gurus,
Oracle version - 11gR2
Can we create 2 objects with same name in same schema?
If not then I have following requirement to fulfill.
In single schema let's for 2 users - user1 and user2, I have to show user1 as complete data and user2 as some masked data but both will fire the same query.
e.g select * from emp;
Assume i have created emp_view with some masked data on say salary column.
My requirement is - when user1 fires query to emp table he will see data as is
and when user2 fires query to emp table he will see masked data for some column that i have created in emp_view
Any suggestions please?
Regards,
Sid