View Single Post
  #2   Report Post  
onedaywhen
 
Posts: n/a
Default

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.

--