Very sorrry,

please replace EXEC above with SELECT

(I always access data via SPs so I'm configured to type GRANT EXEC automatically)

Hi Rolf,

I'm not quite sure what you mean by "automatically".

However, on the off chance that you are looking for the SQL approach (as opposed to using the Enterprise Manager GUI...

Thanks sachin.

I was hoping that the 1st approach would be the preferred one as I have already written a number of stored procedures that use it. I only came...