Hi,
The owner of the table and stored procedure was dbo.
But the user was created now for asp.net application.

Regards
Sukumar

>From: brent.[Email Address Removed] "Sukumar Krishnan" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: Reg: Permission Problem
>Date: Fri, 30 Apr 2004 19:16:39 +1000
>
>Is the owner of the Stored Procedure the same as the owner of the table?
>If not this could cause problems as access rights will be reassessed.
>
>Regards
>Brent
>
>"Sukumar Krishnan" <[Email Address Removed] wrote on 30/04/2004
>05:59:42 PM:
>
> > hi all,
> > we are using dynamic sql statement in stored procedure.
> > Like
> >
> > create procedure getCustomer(
> > @strCustId as string
> > )
> > as
> > declare @sql as varcahr(100)
> > begin
> >
> > select @sql=' select * from customer_master
> > where cust_id in ('+ @strCustId + ')'
> > Execute(@sql)
> > end
> >
> >
> >
> > When a user was given only exceute permissions to the stored procedures
> > when he execute the procedure it shows error like select permission
>denied
> > on the table customer_master.
> >
> > Note. We have given permission to execute the stored procedures
> > The database role of the user is public.
> > When we give the db_datareader permission it works fine. But
>unfortunately
> > we cann't give the permission to the user.
> >
> > Please help me in this problem.....
> >
> >
> > Thanks in advance
> >
> > regards
> > Sukumar Krishan
> >
> > _________________________________________________________________
> > Let your desktop sizzle! Get the hottest wallpapers.
> > http://www.msn.co.in/entertainment/ Right here at MSN Entertainment!
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Get today's cartoon: http://www.LazyDBA.com
> > To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
> > then respond to the confirmation email you get
> > For additional commands, e-mail: mssqldba-[Email Address Removed] >
>
>
>******************************************************************************
> - NOTICE FROM DIMENSION DATA AUSTRALIA
>This message is confidential, and may contain proprietary or legally
>privileged information. If you have received this email in error, please
>notify the sender and delete it immediately.
>
>Internet communications are not secure. You should scan this message and
>any attachments for viruses. Under no circumstances do we accept liability
>for any loss or damage which may result from your receipt of this message
>or any attachments.
>******************************************************************************
>

_________________________________________________________________
Ready cash in just 72 hours. Apply Now !!!
http://go.msnserver.com/IN/46922.asp

MS Sql Server LazyDBA home page