Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 25th, 2006, 12:20 PM
Authorized User
 
Join Date: Jun 2006
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Schema Problem!, Urgent!

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

 
Old June 26th, 2006, 08:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old June 28th, 2006, 01:12 AM
Authorized User
 
Join Date: Jun 2006
Location: , , USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 myusername@mystore.com then put it in a bracket like this [myusername@mystor.com]

GRANT EXEC TO username
GO

  or this script


GRANT EXEC TO [username]
GO


 
Old June 28th, 2006, 06:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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




Similar Threads
Thread Thread Starter Forum Replies Last Post
Database schema arrival123 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 September 26th, 2007 04:47 PM
Getting schema for database Quick209 ASP.NET 2.0 Basics 0 December 12th, 2006 07:51 PM
database problem[urgent] sunanda_chowdary Servlets 0 February 21st, 2006 03:50 AM
Determining a database Schema rit01 Access 2 December 10th, 2005 03:54 PM
Database schema in configuration files hasanali00 BOOK: ASP.NET Website Programming Problem-Design-Solution 2 March 15th, 2005 06:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.