Describe the applied roles/permissions contained in the text file. What can the applicable users do in the BikeStores database? Did any query errors occur? If yes, why?
Task 3: Data Masking
Execute the SQL statements contained in the following text file to implement data masking on two attributes:
BikeStores Masking Application Commands
Discuss what transpires with each command/statement.
Task 4: Column Encryption
BikeStores management has decided that masking customer credit card numbers does not provide sufficient protection. You have now been asked to encrypt the credit card numbers in the database. Execute the SQL statements contained in the following text file to encrypt customer credit card numbers:
BikeStores Encryption Commands
Discuss what transpires with each command/statement. What is the difference between symmetric and asymmetric keys? What are the challenges associated with each encryption key type?
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|