Thanks - This really helps alot in all cases.


At 12:52 13/07/2004, you wrote:

>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)
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004


[Non-text portions of this message have been removed]