we create the report and have the WHERE parameters, If I use HTML composer to reference the procedure and config the parameter as dropdown list.
now, I have several users to use the procedure and HTML, users have diffrent values from dropdown list.
My question is : how can i create the procedure and config the system to do it?

for example:

TABLE FILE CAR
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
WHERE ( CAR.ORIGIN.COUNTRY EQ '&COUNTRY.(FIND COUNTRY,CAR.ORIGIN.COUNTRY IN car).COUNTRY.' ) AND ( CAR.COMP.CAR EQ '&CAR.(FIND CAR,CAR.COMP.CAR IN car).CAR.' );
ON TABLE NOTOTAL
END

If user1 only have the permission to access the data of ENGLAND and user2 only have the permission to access the date JAPAN,how can i create the HTML and config the system to do it?

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

That would require a totally secure system. So, the user has to log on to the system, then either with explicit or implicit (sso option) logon he/she registers witht he webserver, which in turn will notify webfocus clitne and server of who is logged on. The server will then take the users id-ticket and use that to read from the database, which also has to be secure to be able to distinguish between the users.
If this is all in place, then there is nothing to worry about any more, since the system will take of things based on the user's id.

Hi, Gamp
It sounds like very complex,so can you give me some more suggestion or some reference website?

WebFOCUS security and administration manual would do just fine, I think. You can find it on IB's web site.