Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-09-21 : 08:07:52
|
| (nb. ficticious schema/role names just for this thread)I have created a schema (Schema_1) and a database role (Schema1Access), I have set the schema as being owned by that role.I have added members to the role.I have created a table within that schema (Emp_1.table1)I am finding that other users can also see the data in this table!Could this be because they are in the database role db_datreader and db_datawriter?They were added into the db_datareader/writer roles by my predecessor, so will I have to remove all of them from these roles and add them to the seperate schema's/roles that i have started creating? |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-09-21 : 08:57:36
|
| OKfound the info now thanks:-The members of db_datareader database role can see any data from alluser tables in the database.The members of db_datawriter database role can add, change, or deletedata from all user tables in the database.looks like I got some work to do re-assigning roles............ |
 |
|
|
agibson
Starting Member
4 Posts |
Posted - 2009-12-04 : 09:06:54
|
I don't think this is quite correct. That role can be assigned for each individual db. quote:
Originally posted by Bill_C
OKfound the info now thanks:-The members of db_datareader database role can see any data from alluser tables in the database.The members of db_datawriter database role can add, change, or deletedata from all user tables in the database.looks like I got some work to do re-assigning roles............
|
|
|
|
|
|
|
Another role question - Hierarchy!