Re: Very simple SELECT stored procedure permission denied error
From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 10/16/04
- Next message: John Bell: "Re: Linked server"
- Previous message: John Bell: "Re: Very simple SELECT stored procedure permission denied error"
- In reply to: Dot net work: "Very simple SELECT stored procedure permission denied error"
- Next in thread: Dot Net Work: "Re: Very simple SELECT stored procedure permission denied error"
- Reply: Dot Net Work: "Re: Very simple SELECT stored procedure permission denied error"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 16 Oct 2004 10:28:52 -0400
Creating new tables is not something you want to do from a Web
application on a regular basis. If you open a Profiler trace on the
application, you will see that it is using the aspnet worker process
account to connect to the server. This is not an account that you want
to run with the elevated permissions necessary to create database
objects. Reason: it would create a giant security hole. You might find
the ASP.NET Security Best Practices whitepaper helpful, which you can
download from:
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047
--Mary
On 16 Oct 2004 07:12:47 -0700, dotnw@hotmail.com (Dot net work) wrote:
>Hello,
>
>I can't get this very simple stored procedure to execute from within
>my ASP.NET application:
>
>SELECT * into MyTempTable from MyTable
>
>The error returned is
>
>CREATE TABLE permission denied in database 'MyTable'.
>
>I've tried setting lots of permission settings that I can see inside
>Enterprise Manager, but it still won't execute.
>
>Can anyone help please? TIA, regards, dnw.
- Next message: John Bell: "Re: Linked server"
- Previous message: John Bell: "Re: Very simple SELECT stored procedure permission denied error"
- In reply to: Dot net work: "Very simple SELECT stored procedure permission denied error"
- Next in thread: Dot Net Work: "Re: Very simple SELECT stored procedure permission denied error"
- Reply: Dot Net Work: "Re: Very simple SELECT stored procedure permission denied error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
