• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Beginner Permissions Problems

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?
  • 2
1 Solution
Dont u have sql enterprise manager? You should set to dbowner that username and thats it.
brassmonkeyboyAuthor Commented:
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?
brassmonkeyboyAuthor Commented:
You know, I figured it out...

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

Thanks man.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now