Re: ASPNET Select permission denied...

table->properties->permissions->Add...->grant select works for me

i assume you already have added ASPNET user as a DB user - for a test - add the user to the db_owner database role (in security->logins->account properties->user mappings).



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

In SQL Server Management Studio, I select permissons for the object,
then
View schema permissions, then view database permissions, then I can
see all
the Grants checked under: Explicit permissions for ASPNET, which
includes
"Select dbo Grant".
But if I click "Effective Permissions" it shows a list in which
"Select" is
not included. Why would that be when I have Explicitly check grant
all?
,,,Donald

"Dominick Baier [DevelopMentor]"
<dbaier@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4580be6319bbdf8c84c6b4fdde497@xxxxxxxxxxxxxxxxxxxxx

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: 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)
  • Re: ASPNET Select permission denied...
    ... In SQL Server Management Studio, I select permissons for the object, then View schema permissions, then view database permissions, then I can see all the Grants checked under: Explicit permissions for ASPNET, which includes "Select dbo Grant". ... Why would that be when I have Explicitly check grant all? ... in which database role is ASPNET? ...
    (microsoft.public.dotnet.framework.aspnet.security)