brassmonkeyboy
asked on
Beginner Permissions Problems
Here's a description of my setup:
https://www.experts-exchange.com/questions/21383584/SQL-Server-does-not-exist-or-access-denied.html
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?
https://www.experts-exchange.com/questions/21383584/SQL-Server-does-not-exist-or-access-denied.html
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You know, I figured it out...
I went under Roles and added SUBRO\ASPNET to the list of names under dbowner.
Thanks man.
I went under Roles and added SUBRO\ASPNET to the list of names under dbowner.
Thanks man.
ASKER
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?