Hi there

I get this error message when I try to view a page on this site. Does anyone know how I can rectify this?

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

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

Many thanks

Adam

You need to give select permissions on the necessary tables to the user you are using to run the query.

Hopefully one of the other folks here who is more familiar with database security can provide a more detailed answer and some suggestions.

Peter
------------------------------------------------------
Work smarter, not harder.

What's the query that returns this error?

I don't think it's possible to give a much more detailed answer than the one you gave. The user running the query does not have sufficient privilege to access the object 'SystemDefaults' in the database 'bill_test'. The error message can't be any clearer. That user must be granted sufficient privilege to the object to access it.

The OP says he gets the error when "...I try to view a page ...". Just exactly who is "I" in this case? If access to the database is via anonymous access from a web server, then the IUSR_<server> user ID must have sufficient privilege to access the database, etc.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for your input guys. Unfortunately, I'm not the most fast witted sql programmer so I'm not sure how to set the permissions for the I_USER - I know that there are some properties on the table that set permissions but I've tried that and it still doesn't seem to want to work.

Any further comments greatly appreciated

thanks

Adam

Use Enterprise Manager. Select the database, then the Users node. Check to see if the appropriate user is listed as a user of the database. Add it if not. Right click the user, select Properties, then click the Permissions button and give the user the permissions you need.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com