If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Masking Sensitive Columns

Started by timgil, 03 Dec 2009 06:19:13 PM

Previous topic - Next topic

timgil

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?


cognostechie

You can set Data Level security which would prevent Group B from seeing that data at all.

timgil

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.

Mpotla

Can we put some default value if that SSO is not falls under group A  Using Case stmt.

Naven

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

mgibson

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