Error : "SELECT permission denied on object"

[Mr.KisS]

Hi,

In my aspx page i use a stocked procedure and in this
procedure, there is a SELECT query. And whene the aspx page
calls the procedure i get this exception :

System.Data.SqlClient.SqlException: SELECT permission
denied on object 'users', database 'wizou', schema 'dbo'.

So, i must give the authorisation to ASPNET to use SELECT
queries but, i'm on SQL 2005 and there isn't Enterprise
Manager. How to make it with SQLCMD?

Thanks all

 

[Teemu Keiski]

Hi,

could it be this issue mentioned on beta's readme.

"
4.12. SQL Server Express installation does not provide access permission
for the ASP.NET worker process account nor for non-administrators.

The SQL Server Express installation does not grant access to the ASP.NET
worker process identity (ASPNET on Windows 2000 and Windows XP; NETWORK
SERVICE on Windows Server 2003), nor to non-Administrators on the local
machine. As a result, filesystem Web applications will run under the Visual
Web Developer Web Server for users who are not Administrators, and all IIS
Web applications cause permission denied errors at runtime. This is a known
limitation of Web applications that access SQL Server Express databases in
this release.

To resolve this issue

Workarounds for this issue are listed below. However, neither workaround is
recommended on machines that have network connections, since the workarounds
expose serious security holes.

For filesystem Web applications (i.e., Web applications that run under the
Visual Web Developer Web Server): Add the current user to the Administrator
group on the local machine.

For IIS Web applications: Add the ASP.NET worker process identity (ASPNET or
NETWORK SERVICE) to the Administrator group on the local machine.

SQL Server 2000 databases will work for both types of web applications
provided they have been configured correctly to provide access either to the
ASP.NET worker process identity or the current user (or both).
"