September 27, 2013, 03:46 AM
ShankarHide 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.
September 27, 2013, 02:04 PM
RifazIMHO, you might need to dig more into 8.0 Security Center doc. Granular level Security.
September 29, 2013, 11:15 AM
TwanetteHi,
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 ;-)
September 29, 2013, 07:48 PM
SandyMWF 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.
September 30, 2013, 05:55 AM
RifazApologies, 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.htmThanks,
Rifaz