hello all
i've written asp pages with sql server database and i upload my files to internet(i got a host).i recieve error below in my pages:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'UserList', database 'host064', owner 'dbo'.

/login.asp, line 21
and when i want to open my data base that has uploaded to host server with interprise manager i can't open any table it gives me an error like the error that i wrote it above.would some one help me to fix the problem.
thank you

Hi hastikeyvan,

Didn't we do all this here: http://p2p.wrox.com/topic.asp?TOPIC_ID=33110 ??

What did your host say??

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: from the edge of the deep green sea by The Cure (Track 4 from the album: Wish) What's This?

My host didn't check it.because the host datarebase responsible is working there parttime.and didn't go there these days.can't i fix it my self?can i delete the database and upload it again???

I don't think so, unless the you have the password of the SA or another Admin account.

Security in general would be a bit pointless if you could just grant yourself the necessary rights to an arbitrary database, don't you think?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

thank you for your help.my host fix the problem and it is working now.