What is a stored procedure on the server side. I'm an accountant not a
programmer. Can you clarify?



"onedaywhen" wrote:

Excel GuRu wrote:
I would
prefer for security reasons that they cannot edit the query, only
refresh the
query.
Even if we establish Oracle security at
the database level, the query could still be edited.

What about putting the SQL code in a stored procedure on the server
side? I suppose they could still change the calling command text e.g.
to call a different stored proc but a least they couldn't mess with the
query in question.

Jamie.

--