DBM 502 WEEK 5 Protecting Database

$ 15

DBM 502 WEEK 5 Protecting Database

Password protect the database you created for your individual assignment in Week Three.
Create a CRUD 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 command(s) to protect your entire SQL Server database
The matrix (categories of users are rows, categories of data are columns, and R, I, D, and/or M in the cells)
The SQL code for creating logins and 2 specific users from your matrix
The SQL code for granting appropriate permissions to your 2 new users

57 in stock

SKU: DBM502WEEK5N Categories: ,

Description

DBM 502 WEEK 5 Protecting Database

Password protect the database you created for your individual assignment in Week Three.
Create a CRUD 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 command(s) to protect your entire SQL Server database
The matrix (categories of users are rows, categories of data are columns, and R, I, D, and/or M in the cells)
The SQL code for creating logins and 2 specific users from your matrix
The SQL code for granting appropriate permissions to your 2 new users

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.