Re: ASPNET Select permission denied...

and did you check that ASPNET has select permissions on that object??

in which database role is ASPNET?

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

I programmed my web using VS.Net 2005 with the a website as a file
system
and Database as system wide(as in not using the dynamic attach method)
SQL
2005 DB.
I had no problem during development. Finally, I published my web and
I get
the following error:
SELECT permission denied on object ....

My connection string is:
<add name="defaultSqlServer" connectionString="Server=.;Integrated
Security=SSPI;Database=MetaBase"
providerName="System.Data.SqlClient"/>
or
<add name="defaultSqlServer" connectionString="Server=.;Integrated
Security=True;Database=MetaBase"
providerName="System.Data.SqlClient"/>
Both work before publishing.
The aspnet login is successful, but that error occurs with any other
kind of
db access. So I set the ASPNET account to have grant access to all
permissions and dbo as the Grantor, but I still get that error. I
have
confirmed that the actual user is ASPNET via the SQL Profiler.
Any help would be appeciated.
Thanks in advance,
Donald Adams


.

Relevant Pages

  • Re: How Bad Is It?
    ... The ASPNET account did not have permissions to multiple files ... Lee used FileMon and RegMon. ... Run them and look for the functions to turn logging on & off, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • ASP.NET process identity does not have read permissions to the global assembly cache.
    ... "Server Application Unavailable ... determined that aspnet_wp.exe is running as ASPNET. ... Verified that the ASPNET user has read permissions to WINNT\assembly ... process identity doesn't have read permissions to the GAC when it does? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASPNET Select permission denied...
    ... i assume you already have added ASPNET user as a DB user - for a test - add ... Dominick Baier - DevelopMentor ... View schema permissions, then view database permissions, then I can ... "Select dbo Grant". ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ASP to ASP.NET Error 80070005 (JScript.NET)
    ... Permissions" and "Configuration Permissions" then save. ... COM object working for ASPNET. ... To get it working I had to remove the "Internet Guest Account" ... computer (where manually moving/adding -> restarting didn't work) I ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.NET process identity does not have read permissions to the global assembly cache.
    ... make sure that the ASPNET account ... The User profile directory is used by the GAC cache lock files and the security ... review the necessary permissions list found at this page: ... "Server Application Unavailable ...
    (microsoft.public.dotnet.framework.aspnet)