Tom Kyte has examples for this under returning recordsets from oracle
procedures on his web site
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Stanislaw Findeisen" <findeisen_at_zodiac.mimuw.edu.pl> wrote in message
news:3A4CA7FB.904C501E_at_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 Wed Jan 03 2001 - 06:26:16 CST
