Re: ASP page and SQL server error

From: Kevin Spencer (kevin_at_takempis.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 15:38:10 -0500

It's not the account, it's the priveleges that the account has with regards
to the database. SQL Server permissions are very granular (configurable). In
this case, while the user has permission to USE the database (in a general
sense), the user doesn't have permission to execute SELECT statements on
that database. This would be granted via SQL Server administration. You
should make sure that the user has permission to execute whatever types of
operations you're planning to use in your database. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Cinderella" <anonymous@discussions.microsoft.com> wrote in message
news:FEEE101A-33D8-4B44-8943-11679F12451C@microsoft.com...
> Hi guys,
>
> I am trying to connect to SQL server from ASP page. My DBA created a
public user account in SQL server for me. But I got an error message like
this when I try to run my asp page:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on
object 'book', database 'book database', owner 'dbo'.
>
> /database/index.asp, line 5
>
> Am I correct that the user account needs more access than a public user to
execute this page? What kind of user account does it need to me?
>
> Thanks.
>
> Cinderella
>