AndyLL
Perch
My scripts run on clients domains that they have access to so I wanted to protect my admin user.
I created a new Login - WOBUser
I created a new user in the db using that Login - WOBUser
I couldn't change permissions but by default it looks like it is public which has DataReader permission which is what I what.
When I try to access the DB:
select count(*) from Categories where ...
I get:
SELECT permission denied on object 'CATEGORIES', database 'wobbook_BookSite', owner 'dbo'.
I can login to the DB using this ID through Query Analyzer but doing a select I get the same error.
What am I doing wrong?
Andy
www.DisneyMouseLinks.com
I created a new Login - WOBUser
I created a new user in the db using that Login - WOBUser
I couldn't change permissions but by default it looks like it is public which has DataReader permission which is what I what.
When I try to access the DB:
select count(*) from Categories where ...
I get:
SELECT permission denied on object 'CATEGORIES', database 'wobbook_BookSite', owner 'dbo'.
I can login to the DB using this ID through Query Analyzer but doing a select I get the same error.
What am I doing wrong?
Andy
www.DisneyMouseLinks.com