A question about MS SQL Server database design# Database - 数据库
d*t
1 楼
Hi, everyone,
I have a task to design a database in MS SQL Server 2005 for a group. Each
member of the group should have his own schema that is not accessible to
other members while there is a common schema shared by all members. I can
set up a database role for the members. My problem is how to prevent members
from accessing others' schema. Any help will be greatly appreciated.
Thanks.
I have a task to design a database in MS SQL Server 2005 for a group. Each
member of the group should have his own schema that is not accessible to
other members while there is a common schema shared by all members. I can
set up a database role for the members. My problem is how to prevent members
from accessing others' schema. Any help will be greatly appreciated.
Thanks.