Hello all

I got an exception thrown from the ExecuteNonQuery method of the DataAccess class that I dont have permission / 'dbo' schema to access the stored procedure.
I am using a shared hosting database, so I don't the role membership of db_dbowner


Any suggestions would be appreciated

Just report the problem to your hosting company and they'll fix it for you. You need to have the dbo role in your own database!

By the way, to see your own roles:

exec sp_helproles

Eric

You don't have to be dbo (database owner) to have that EXECUTE permission to stored procedure.

By doing the following steps:
1) Log in to your remote database using SSMS or SQL Sever Management
Studio (Start -> All Programs -> Microsoft SQL 2005
-> SQL Sever Management Studio)

2)Open a new query windows
3) Type this in the query window then hit F5 key to execute the script (replace username with your real username, it your username contains a period, for example [email protected] then put it in a bracket like this [[email protected]]

GRANT EXEC TO username
GO

  or this script


GRANT EXEC TO [username]
GO

But you can still have naming issues with schemas other than dbo. I just wouldn't want to deploy to a DB where I'm not in the dbo role, even if I could make it work. I'm paying for the hosted DB, so at least that particular DB needs to be mine.

I can understand not having admin access to the server, since many people share it and you want to keep a wall of separation between users so one guy doesn't harm, or even look at the data from another DB on that server.

Eric