Beginner Permissions Problems

Posted on 2005-04-11
Last Modified: 2010-04-07
Here's a description of my setup:

That solution fixed the specific problem I was having, but every time I try to access a different part of Northwind I have to specifically grant permissions.  For instance, I just got this error:

SELECT permission denied on object "Product Sales for 1997', database 'Northwind', owner 'dbo'.

I typed this:

osql -E -S (local)\BasicDB -d Northwind -Q "grant select on Product Sales for 1997 to [COMPUTER_NAME\ASPNET]"

Apparently there's some syntax error here...but the problem is bigger than this...the problem is that I shouldn't have to specifically grant permission for every part of the database.  What's going on here?
Question by:brassmonkeyboy
    LVL 10

    Accepted Solution

    Dont u have sql enterprise manager? You should set to dbowner that username and thats it.

    Author Comment

    No, I'm using MSDE.  I DO have a substitute program that does a FEW of the functions of Enterprise Manager.

    I don't understand your suggestion.  Do you mean (1) I should set a username to "dbowner" or (2) set the account I'm using to be the dbowner?

    Author Comment

    You know, I figured it out...

    I went under Roles and added SUBRO\ASPNET to the list of names under dbowner.

    Thanks man.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
    User art_snob ( encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now