Focal Point
Hide fields in IA

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3257077336

September 27, 2013, 03:46 AM
Shankar
Hide fields in IA
Hi All,

How can we restrict certain set of users from displaying certain set of columns in infoassist Reporting object left panel?
We have field 'username' in underlying datasource which we can query and accordingly hide columns.
Suppose we have col1,col2,col3,col4 and col5 in a reporting object. I want to hide col1 and col3 for few users in same reporting object and show all columns for other users.

Please advice.

Thanks.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
September 27, 2013, 02:04 PM
Rifaz
IMHO, you might need to dig more into 8.0 Security Center doc. Granular level Security.


-Rifaz

WebFOCUS 7.7.x and 8.x
September 29, 2013, 11:15 AM
Twanette
Hi,

I was hoping to get the "DBA" functionality to work. (See the "Describing Data with WebFOCUS Language" manual)
I did a test on 8.0.03. At the very end of my master file I added this:
END
DBA=XYZ,$
USER=TWANETTE,ACCESS=R,RESTRICT=FIELD,NAME=DATE_OF_BIRTH,$
When I ran a simple "PRINT *" from the server http console:
User XYZ had access to everything.
User TWANETTE had access to all fields except DATE_OF_BIRTH (i.e. this column did not print)
But, I couldn't get it to work with InfoAssist.

The other option would possibly be to dynamically generate a master file or business view. It does however depend on what type of data source you are reading.

If nobody else responds you should perhaps log a call for it. And then please post the solution for us to see as well ;-)


WebFOCUS 8.2.06 mostly Windows Server
September 29, 2013, 07:48 PM
SandyM
WF V8 security does not provide capabilities to control access to specific data fields. It does provide capabilities to control access to content (reports and charts, HTNL pages)and other objects such as folders and URL links.

To control access to specific data fields you will probably need to use the DBA security capabilties and should consider a group profile to designate the users that should have controled access to specific master files or data elements within a masterfile. A group profile with DBA security will make it easier to manager the users. You can set DBA security for individual user profiles also.

DBA security can also be used with earlier versions of WebFOCUS.


Prod: WF 8.005 Windows, all output formats
Dev: WF 8.005
September 30, 2013, 05:55 AM
Rifaz
Apologies, I should've read the post carefully.

Check this link, this is from 7704. But,not sure in IA as Twanette said. Better, you try it once.
http://documentation.informati...f/source/topic26.htm

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x