Anyone know a solution within FM to mask data from sensitive columns like SSN so that Group A can see the data but Group B sees a mask, or nothing at all for that column?
You can set Data Level security which would prevent Group B from seeing that data at all.
Yes, but that will remove rows from the resultset. I want to be able to show the row but just mask the SSN column for a particular set of users.
Can we put some default value if that SSO is not falls under group A Using Case stmt.
Hi,
You can create one more column of SSO which contains null\default value.
Then dynamically substitute columns based on the user groups.
This could be achieved through parameter maps in FM if I am not wrong.
Regards,
Naveen
Isn't that what 'Object Security' is for? See the Security chapter of the FM guide.
But you've probably already solved your problem by now.
Mick