Question
Data Security
Password protect the database you created for your individual assignment in Week Three.
Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database.
Create at least two different users and implement their permissions using SQL statements.
Submit the following deliverables to your instructor:
The steps you took to password protect the database
The matrix
The SQL code for creating the users and implementing their permissions
Using either MySQL, SQL Server, or SQL Manager. Need screenshots and coding in word.
Password protect the database you created for your individual assignment in Week Three.
Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database.
Create at least two different users and implement their permissions using SQL statements.
Submit the following deliverables to your instructor:
The steps you took to password protect the database
The matrix
The SQL code for creating the users and implementing their permissions
Using either MySQL, SQL Server, or SQL Manager. Need screenshots and coding in word.