This assignment, you will analyze and implement database security best practices. You will first create a security
Question:
This assignment, you will analyze and implement database security best practices. You will first create a security checklist and a backup plan using resources provided in the lecture and reading materials. You will then implement these components into the AdventureWorks database that you previously downloaded.
Perform the following:
- A Database Security Checklist.
- A Database Backup/Recovery Plan.
- Implement the Security Checklist to the AdventureWorks Database.
- Perform a Database Backup.
Using a single Word document, submit the following:
- A Database Security Checklist
- A Database Backup/Recovery Plan
- Screenshot of how checklist items were implemented
- Screenshot of database backup command use
This is the AdventureWorks database:
these are the tables inside of AdventureWorks database:
Tables_in_adventureworks |
+---------------------------------------+
| address |
| addresstype |
| awbuildversion |
| billofmaterials |
| contact |
| contactcreditcard |
| contacttype |
| countryregion |
| countryregioncurrency |
| creditcard |
| culture |
| currency |
| currencyrate |
| customer |
| customeraddress |
| databaselog |
| department |
| document |
| employee |
| employeeaddress |
| employeedepartmenthistory |
| employeepayhistory |
| errorlog |
| illustration |
| individual |
| jobcandidate |
| location |
| product |
| productcategory |
| productcosthistory |
| productdescription |
| productdocument |
| productinventory |
| productlistpricehistory |
| productmodel |
| productmodelillustration |
| productmodelproductdescriptionculture |
| productphoto |
| productproductphoto |
| productreview |
| productsubcategory |
| productvendor |
| purchaseorderdetail |
| purchaseorderheader |
| salesorderdetail |
| salesorderheader |
| salesorderheadersalesreason |
| salesperson |
| salespersonquotahistory |
| salesreason |
| salestaxrate |
| salesterritory |
| salesterritoryhistory |
| scrapreason |
| shift |
| shipmethod |
| shoppingcartitem |
| specialoffer |
| specialofferproduct |
| stateprovince |
| store |
| storecontact |
| transactionhistory |
| transactionhistoryarchive |
| unitmeasure |
| vendor |
| vendoraddress |
| vendorcontact |
| workorder |
| workorderrouting |
+---------------------------------------+
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds