![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
<Viswa> |
Hai I have CAR ,master file. I have a fex file like : ONE.FEX TABLE FILE CAR PRINT * ON TABLE SET ONLINE-FMT HTML END If i execuet one.fex file, it will return all the rows. My requirement is, If i execute the fex file, i need to see the rows, for which country = FRANCE. I don't want to limit in the fex file. I want to put that limit in the master file. Please let me know, how can i acheive the same. Thanks ViswakanthThis message has been edited. Last edited by: FP Mod Chuck, | ||
|
Platinum Member |
The implementation of Data Source Security in your master file could help..., FILENAME=CAR,SUFFIX=FOC ... END DBA=MIKEL,$ USER=VISWA1, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN, VALUE=COUNTRY EQ 'FRANCE', $ USER=VISWA2, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN, VALUE=COUNTRY EQ 'ENGLAND', $ USER=VISWA3, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN, VALUE=COUNTRY NE 'FRANCE', $ Anyway, using this method, you need add SET PASS=VISWA1 in your fex or profile (not in the report). Otherwise, you will get a security error. SET PASS=VISWA1 TABLE FILE CAR PRINT * END Regards, MikelThis message has been edited. Last edited by: <Mabel>, | |||
|
<Viswa> |
Hai Mikel How to add it in the profile? Please let me know Viswa | ||
|
Platinum Member |
Using DBA security (see previous example) and creating a domain profile with generic SET PASS may be a good solution. Regards, MikelThis message has been edited. Last edited by: <Mabel>, | |||
|
Expert |
The 'MFD PROFILE' should do the trick. It's new to WebFOCUS 8x, maybe sooner. I know this is an old thread. But, it came up in a search for something else that was significant. So, I added my Two Cents here for searching. | |||
|
Guru |
I will also add to this ancient thread - if you use the DBA security as shown in the answers here, you might consider SET PERMPASS in the profile instead of just SET PASS. That way a user cannot override it. Also you will probably want to disable SQL PASSTHRU since that will bypass your DBA security rules. Webfocus 8 Windows, Linux | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|