Hi,

At July 13, 2004, 07:32, Johannes Pretorius wrote:

> SECURITY
> ========
> Now the benefit of the view is that a user can have rights to the
> view but not the underlying tables
> the view must just have rights to those tables.

> My question is can this security feature also be implemented with stored procedures.

Yes.

> PERFORMANCE ISSUE
> ==================

> Now the second question is the performance for a stored procedure to return a result
> against a normal query ? I believe that the normal query will be faster as the stored procedure
> but I won't have the security.

> Is there any other alternative or must we just decide what is the
> most important the security or the
> speed and the chose ?

With stored procedures, you will get speed(depending on how you write
your stored procedure) and security(same way as views).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)