returning tables ?

From: Stanislaw Findeisen <findeisen_at_zodiac.mimuw.edu.pl>
Date: Fri, 29 Dec 2000 16:04:27 +0100
Message-ID: <3A4CA7FB.904C501E@zodiac.mimuw.edu.pl>

Hi,

Suppose I have a database consisting of 2 tables containing some information about multiple users, for instant:

PEOPLE

---

person_id [ primary ]
name

PLACES_VISITED

---

person_id [ foreign ]
city

and now I'd like to make a Web interface (in PHP for instant) allowing every user to list the places he's already visited. Of course no one should be able to see the information about the others. How to do this?

1). If the "users" are in fact database users, then I can make a View for each of them, and then simply select * from it, am I right ? Is there any way to execute some stored procedure instead of selecting in such a direct way and achieve the same result (get a result table on WWW page) ?

2). How to protect the information about the others if the users are NOT database users (there are only 2 accounts - the "Admin" and the "User") (the identification process and logging procedure is performed on the Web application level, not on the server) ? What I would like most would be a call to a stored procedure returning an appropriate table - this way the User could have no rights to any table, just to the procedure. How to do this ?

These two cases are in fact the same qouestion - how to make a procedure returning a table for displaying on WWW page ? (but WITHOUT htp functions).

Any help appreciated.
Thanks. Received on Fri Dec 29 2000 - 09:04:27 CST