|
MUKE YA MUHA
Starting Member
Tanzania
4 Posts |
 Posted - 08/03/2012 : 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 nothing
The 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 abilities
How will you go about creating this security architecture? |
|
How to manage access right
