Thanks for the response.
=\-=\=-\=-\-==-\=\-=-\
On the security , can I give a user only rights to a stored procedure and then
give the stored procedure rights to the tables it requires ??

I want to create a view only screen of the data but don't want to allow any other tables to be seen. This will
be given to other packages to connect with.

Thanks again

Johannes



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

>> Is there any other alternative or must we just decide what is the
>> most important the security or the
>> speed and the chose ?
>>
>> Thanks in Advance
>>
>> Johannes Pretorius
>
>I use stored procedures for selecting data (not infrequently). I think you
>(like I was to begin with) will be very pleasantly surprised by the overall
>performance on using SPs to select data.
>Alan
>
>
>
>
>
>
>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]