A question about designing a database in MS SQL Server 2005 Express

• Marvin-395039

  Newbie

  Points: 5

  More actions

  January 7, 2007 at 8:05 pm

  #171765

  Hi, everyone,

  I have a task to design a database in MS SQL Server 2005 Express for a group. Each member of the group should have his own space to maintain his objects and that space should not accessible to other members. There should also be a common space where all members can share data. I set up individual schemas for group members in a database and created a database role for all members. My problem is how to prevent members from accessing others' schema. I can manually set it up but I think it is too tedious and trivial. Is there a smart way to do it? Any help will be greatly appreciated.

  Thanks.

• January 10, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Terry Grignon

  SSC Eights!

  Points: 840

  More actions

  January 19, 2007 at 7:23 am

  #684293

  I would do it the manual way (make everyone dbo's of their own db's and all members of the master db)... or script it for one user and then parameterize the script for userid. But I'm not sure... details would be needed.