Good Morning!

I am attempting to set up dynamic security on a synonym that we will be using for infoassist.

Basically, a WEBFOCUS should only have access to certain RepNumbers. We want to have a stored procedure that will be passed the WEBFOCUS user id and lock down the synonym to those rep numbers.

Here is what I have so far.

END
DBA=DBA, $
USER=, ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=REP.REPNUMBER IN FILE synonym1.ANSWERSET1.REPNUMBER;, $

Synonym1 is master that is a stored procedure. When I hooked it up to a report I get this error message.

0 ERROR AT OR NEAR LINE 1 IN PROCEDURE Report1.fexFOCEXEC *
(FOC351) INPUT FILE NOT ALLOCATED: synonym1.ANSWERSET1.REPNUMBER
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND


I feel like I am close but am missing something. Thoughts?

Thanks for your help in advance

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

A helpful diagnostic test would be to see if the master works when you hardcode VALUE=.

Doc says: "The test is an expression supported in a WHERE phrase." You could see if this would work as a where test in a report just to make sure it behaves the way you expect.

Also, I'm pretty sure this syntax for WHERE compares a field with the values in a temp file. For instance, if you try this code HOLD will contain ENGLAND and JAPAN and when you test against HOLD you only get cars from those two countries.

 
TABLE FILE CAR
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN';
ON TABLE HOLD
END
TABLE FILE CAR
SUM RCOST
BY CAR
WHERE COUNTRY IN FILE HOLD
END

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

Yes, when I hard code the values to a static set of numbers it works as intended.

Can I initiate a hold file inside of synonym? I guess that is my question is how do I have the file created so I can then reference it in my DBA.

The best approach would be to use a master file profile. Look it up in the doc. Syntax is FILE = filename, SUFFIX = suffix, MFD_PROFILE = app/fexname,$

quote:

VALUE=REP.REPNUMBER IN FILE synonym1.ANSWERSET1.REPNUMBER

This Post might be better served in the WebFOCUS forum if it relates to processes outside of specifically InfoAssist reporting.

Here is a link that looks similar to what you are trying to do with example.

Master file DBA
Note the DBA security and the VALUE=DIV EQ (HOLDDIV),$

The above is a HOLD file that has been created within the MFD_Profile fex

Please review - Creating and Using a Master File Profile

Creating and Using a Master File Profile

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders

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