Guro needed for Web-only database security and privileges

I have searched all over and this should be a real easy answer but can't seem to find it.

I have two databases say PRODUCTS and ORDERS that are called from a web interface only IWP database. Clients log into the web only database with their privileges, but I noticed they can not see data in any of the related tables (unless i create a matching account), as they do not have accounts in these. Since accounts are created often and there will be many users it is not possible or practicle to create matching accounts in the two sub databases.

I know that any privileges that are created in one file are rippled up through any related files, but how do I just have the web interface file manage accounts and not all three. I have tried just creating privilege set that match but this does not do it.

I would really appriciate any help, as I know that there is an easy solution, but as you know searching the forums is not easy unless you know what you are lookinjg for.

Regards

Charles

Edited March 14, 200817 yr by Guest