Post reply

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

  • 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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply