SqlException: EXECUTE permission denied on object

[Ivan Simurina]

I m getting the following error once i initiate a page that connects with
database.

SqlException: EXECUTE permission denied on object 'sp_items_for_sale',
database 'bids', owner 'dbo'.]

what should i do to correct this?

thanx

 

[Jon Skeet [C# MVP]]

I m getting the following error once i initiate a page that connects with
database.

SqlException: EXECUTE permission denied on object 'sp_items_for_sale',
database 'bids', owner 'dbo'.]

what should i do to correct this?

Either change which user you're connecting as, or talk to your DBA to
get access to that stored procedure.

 

[Jim Hughes]

Grant permissions to the stored proc to the user who is trying to execute
it, i.e. ASPNET for a web server.

Also, user written stored procs should not use the sp_ or xp_ prefixes, SQL
Server will look in the MASTER database for the proc before looking in the
BIDS database causing performance degradation.

 

[Ivan Simurina]

Grant permissions to the stored proc to the user who is trying to execute
it, i.e. ASPNET for a web server.

How do i do that?

thanx

 

[Jim Hughes]

How do i do that?

thanx

http://support.microsoft.com/default.aspx?scid=kb;en-us;815154

If you don't have Enterprise Manager, you could use the Web Admin tool at
http://www.microsoft.com/downloads/...98-c57a-419e-acbc-2a332cb7f959&DisplayLang=en

 

[Frans Bouma [C# MVP]]

How do i do that?

Execute the following query in query analyzer to give ASPNET access rights to
execute the proc:

GRANT EXECUTE ON [dbo].[sp_items_for_sale] TO [ASPNET]

FB