Limiting table views in Supervisor

Need some help. I am trying to limit the rows within a table that a user can see. I have gone into Supervisor, brought up the properties of the universe I am limiting and then put in the table and WHERE clause to restrict the particular user. (In this case I am limiting the customer table where the assigned salesperson is equal to the user logging in) However, when I log in as the user I have restricted, I can still see the full set of results for ALL customers. What am I doing wrong. The WHERE clause parses OK in Supervisor. Any assistance is appreciated. Michele Robertson
Analyst
Second Floor San Dimas
Pax 47573


Listserv Archives (BOB member since 2002-06-25)

“Robertson, Michele R” ROBERTM1@SCE.COM wrote :

“I am trying to limit the rows within a table that a user can see.” Michele Robertson

Analyst
Second Floor San Dimas
Pax 47573

Michele,

You should check the SQL generated by this query and verify that this restricted table is really part of the FROM clause. If not, then check the object definition that you think should use this table (with the Designer module).
Most of the time, the SQL generated for a query will bring you a good clue ;o)

Farfadet.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com


Listserv Archives (BOB member since 2002-06-25)