We're implementing DBA security here. I have some tables where user A can have full access, but user B has no access. If user B starts InfoAssist, in the list of available tables that pops up, the restricted table appears in the list. However, when he tries to open it he gets the security error, which is correct. I would prefer that the restricted table not even show up on his list. Is there a way to do that? Thanks.

This message has been edited. Last edited by: Kerry,

Mike

I don't think it's possible, because I assume WF is only looking for the .mas files, never at the data itself. I suppose you could separate the .mas files into different dirs and set the APP PATH differently for different users.

Håkan

Hi

You can control which master files are displayed for a user in InfoAssist using the following technique:
TM4550
Customizing the Display of Applications, Files, Fields, and Field
Descriptions in WebFOCUS Development Tools

http://documentation.informati...pdf_wf_52/tm4550.pdf

using a built-in global variable &&IBI_IF_FILE which will eventually refer to filtering statement on the list of master files rendered for a user in infoassist
I checked it in 7611 and it works

Thanks for the idea, but it sounds like that would be a maintenance nightmare. I was hoping that the tools would respect the DBA security when they display the list of available files.

interesting solution
we where looking at this too

Hi
Regarding Maintenance: if you create "dynamic" dba files, meaning that you manage all security settings in an external relational table , for example, then you could also parameterize and create "on the fly" the excluded master files list from the same source or just manage it in a seperate relational table.