View Single Post
  #7 (permalink)  
Old August 27th, 2011, 11:41 AM
grouchy grouchy is offline
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Getting there I think, but my book doesn't have a 766 but 700 looks roughly right.

So, although my db works fine for content, I must specifically create (re-create) the roles required on the server to support access for my roles via the login.

I do this by opening my database on the host server, and then security, roles, database roles. Right click lets me create a new role i.e. 'manager'. This then appears as a role.

Not quite sure how to allocate permissions - do I (for example) then open db_reader and add 'manager' as a role member?

thanks.
Reply With Quote