I m getting the following error once i initiate a page that connects with
database.
SqlException: EXECUTE permission denied on object 'sp_items_for_s ale',
database 'bids', owner 'dbo'.]
what should i do to correct this?
thanx
5  3237 
Ivan Simurina <ha**@hehe.co m> wrote: I m getting the following error once i initiate a page that connects with
database.
SqlException: EXECUTE permission denied on object 'sp_items_for_s ale',
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.
--
Jon Skeet - <sk***@pobox.co m> http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
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" <ha**@hehe.co m> wrote in message
news:c7******** **@ls219.htnet. hr... I m getting the following error once i initiate a page that connects with
database.
SqlException: EXECUTE permission denied on object 'sp_items_for_s ale',
database 'bids', owner 'dbo'.]
what should i do to correct this?
thanx
"Jim Hughes" <NO*********@Ho tmail.com> wrote in message
news:ev******** ******@TK2MSFTN GP10.phx.gbl... 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
Ivan Simurina wrote:
"Jim Hughes" <NO*********@Ho tmail.com> wrote in message
news:ev******** ******@TK2MSFTN GP10.phx.gbl... 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?
Execute the following query in query analyzer to give ASPNET access rights to
execute the proc:
GRANT EXECUTE ON [dbo].[sp_items_for_sa le] TO [ASPNET]
FB
--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Zeke Hoskin |
last post by:
Suddenly a stored procedure, very much like several others, is giving
EXECUTE permission denied on object 'Add_Adjustment', database
'InStab', owner 'zhoskin'.
server:Msg 229, Level 14, State 5, Procedure Add_Adjustment, Line 18.
I'm zhoskin. I am the dbo and created the procedure, and when I look
at its properties, I have EXEC permission....
|
by: Ken |
last post by:
Hi guys,
this is a curios thing, everything was working fine then I had to restore my
development machine( VS.NET, SQL server etc) now I'm receiveing this error
from my asp aplication only in RELEASE mode, but everything works good in
DEBUG mode, this is happening when I run my app against my local SQLDB and
against a hosting DB.
...
|
by: Mike L. |
last post by:
Hi,
I got this 'EXECUTE permission denied on object <mySproc>' error message
everytime I try executing my SQL server Sproc.
What's this and how to fix this err?
many thnaks in advance,
mike
|
by: nandakumar.raghu |
last post by:
Hi,
I have written a javascript function that acceses properties from an
activex object. -
<OBJECT id="alertObj"
classid="clsid:AEE77194-B98F-4E0E-A27F-4AD6B23F0038"></OBJECT>
function onLoadfunc()
|
by: ajos |
last post by:
hi frnds,
im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception.
to verify this error ive made a simple database in jsp(just to check if my mysql is working smoothly otherwise) which access' the username.....but in the process im getting a...
| | |
by: Tony Proctor |
last post by:
I need to create a process Singleton object for an ASP application, but I'm
having some odd issues
In my GLOBAL.ASA, I have an <OBJECTelement specifying the relevant ProgID
with RUNAT=Server and SCOPE=Application
However, although this works fine for some classes, I get a permission
denied error for classes from a particular DLL. The...
|
by: Jeff |
last post by:
asp.net 3.5
I've created a database in Sql Server 2005 for my asp.net project. I used
aspnet_regsql to add membership tables and stored procedures.
Then I added a login/user to this database. Default schema for this user is
dbo.
When I try to execute my asp.net webpage I get this error:
EXECUTE permission denied on object...
|
by: private.anders |
last post by:
Really need assistance since I have been struggling with a problem
long time now.
I am running a web application on a Win 2003 Std (Active Directory).
Everything works fine. I have installed same application on another
server Win 2003 R2 Std (No Active Directory). On that server I get
“Permission denied” using the following code (used to...
|
by: xzzy |
last post by:
I have a v1.1 web app that works on my local computer. However, running it
at the host computer, the following breaks:
when a viewer selects a different country, the State dropdown should
repopulate with the new country's state/proviences.
Running on the host, the dropdown does not repopulate and says 'Permission
Denied', I take this to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
