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 |
|
MUKE YA MUHA
Starting Member
4 Posts |
 Posted - 2012-08-03 : 04:51:51
|
| you are DBA for Sunnyside Supermarket. You have been asked to provide SQL Sever 2008 implementation in your enviroment. The single server contains three database: Sales, Inventory and dsupport. Everyone in the management should have access to the dSupport database with the ability to read data and nothingThe entire Sales Department should have access to the Sales database in read only mode , and the Manager of the Sales Department should have the ability to read and write the data, including updates on existing data.Finally , all warehouse works should have update and read abilities on the inventory database, while the warehouse managers should have the ability to add new records in addition to update and read abilitiesHow will you go about creating this security architecture? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-08-03 : 05:20:19
|
Try Microsofts Learning Centre as this is where the question is from.  But as a hint, you might want to look at roles. |
 |
|
|
|
|
|
How to manage access right