You can set access rights of the table for the stored procedure.

Daniel Rail
Senior System Engineer
ACCRA Med Software Inc. (www.filopto.com)

At 23/01/2001 06:41, you wrote:

>A table has full permissions for admin but reference only for users
>
>A stored procedure called by users needs to access above table.
>I get a permission access problem here.
>
>Is there a way to login as a different user from within a stored
>procedure to access above table?
>
>Or could I tell inside a procedure that I am actually admin who
>created the procedure in the first place anyway?
>
>Cheers
>
>Johannes
>
>
>
>eGroups Sponsor
><http://rd.yahoo.com/M=168002.1291681.2888959.2/D=egroupmail/S=1700007183:N/A=564957/*http://www.columbiahouse.com/gateway?token=7416>
>Choose 3 DVDs for $0.49 each!