[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Beginner Permissions Problems

Posted on 2005-04-11
Medium Priority
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
  • 2
LVL 10

Accepted Solution

djhex earned 1000 total points
ID: 13758978
Dont u have sql enterprise manager? You should set to dbowner that username and thats it.

Author Comment

ID: 13759021
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

ID: 13759102
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User art_snob (http://www.experts-exchange.com/M_6114203.html) 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.…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Integration Management Part 2
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month19 days, 9 hours left to enroll

872 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