Re: Select permission denied on object [tablename] database
From: Nicholas Paldino [.NET/C# MVP] (mvp_at_spam.guard.caspershouse.com)
Date: 09/21/04
- Next message: Nicholas Paldino [.NET/C# MVP]: "Re: Determining whether DataTime structure is initialized"
- Previous message: Mark Allison: "Re: Learning delegates and events"
- In reply to: Reshma Prabhu: "Select permission denied on object [tablename] database"
- Next in thread: Reshma Prabhu: "Re: Select permission denied on object [tablename] database"
- Reply: Reshma Prabhu: "Re: Select permission denied on object [tablename] database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 08:47:03 -0400
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: Nicholas Paldino [.NET/C# MVP]: "Re: Determining whether DataTime structure is initialized"
- Previous message: Mark Allison: "Re: Learning delegates and events"
- In reply to: Reshma Prabhu: "Select permission denied on object [tablename] database"
- Next in thread: Reshma Prabhu: "Re: Select permission denied on object [tablename] database"
- Reply: Reshma Prabhu: "Re: Select permission denied on object [tablename] database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
