Re: Select permission denied on object [tablename] database
From: Reshma Prabhu (ReshmaPrabhu_at_discussions.microsoft.com)
Date: 09/22/04
- Next message: Maverick: "Re: conio.h --> window (int left, int top, int right, int bottom)"
- Previous message: Shani: "Exe Vs Windows Service"
- In reply to: Nicholas Paldino [.NET/C# MVP]: "Re: Select permission denied on object [tablename] database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 20:49:03 -0700
Hello,
I have created ASPNet local user and given him rights to fire
SELECT,Create,Delete on the tables but still it is not working.
Is any thing else needs to be done?
Thanks,
Reshma
"Nicholas Paldino [.NET/C# MVP]" wrote:
> Reshma,
>
> Is this an ASP.NET process? If it is, then you might not have the
> appropriate permissions (by default, it uses the ASPNET local user). If
> your SQL server is running in Windows Authentication mode, it might not be
> set up for this user.
>
> Hope this helps.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mvp@spam.guard.caspershouse.com
>
> "Reshma Prabhu" <ReshmaPrabhu@discussions.microsoft.com> wrote in message
> news:A72AA9F0-ED9B-4BC1-8F4C-FDE3FA74AB54@microsoft.com...
> > Hello,
> >
> > I am getting following exception while trying to execute a
> > SELECT query on a table even though it has all the SELECT rights. The
> > SQLServer is running on local machine. The server running under windows
> > authentication.
> >
> > Exception---
> > Select permission denied on object [tablename] database [databasename]
> > owner='dbo'
> >
> > The connection is getting opened but it is throwing the exception in
> > myCommand.ExecuteReader() statement in the following code.
> >
> > conn.Open();
> > SqlDataReader reader = myCommand.ExecuteReader();
> > conn.Close();
> >
> > Can anybody please help me out to solve this problem.
> >
> > Thanks,
> > Reshma
>
>
>
- Next message: Maverick: "Re: conio.h --> window (int left, int top, int right, int bottom)"
- Previous message: Shani: "Exe Vs Windows Service"
- In reply to: Nicholas Paldino [.NET/C# MVP]: "Re: Select permission denied on object [tablename] database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
