M$10$: Case Study $-$ Bob's Home Repair Part $2$

Your next step in developing Bob's Home Repair database is to add users and grant user access permissions. There are two

different users of the Bob's Home Repair database.

Bob

Wendy who is the assistant that helps Bob manage his business

Use your Microsoft SQL Server database, not the MySQL database you used in Module $8$ and $9,$ to create your DCL for the

following requirements.

Suggestion: In Module $7($Introduction to DCL$-$SQL$)$ we studied the topic of DCL and permissions using Microsoft SQL Server.

I would suggest you go back and review the homework and videos from this module before you start your homework for this

week. These videos, from module seven, provide several helpful hints.

Requirements:

Add Bob as a login and user to the database and assign a secure password. $($Bob$\text{'}$s Home Repair policy is that passwords

should be at least $10$ characters composed of at least one each, upper$-$ and lower$-$case characters, numbers, and special

characters$).$

Configure Bob's database access so he can:

View all data in all tables.

Read$/$write$/$modify$/$delete any data in any table.

No other permissions are to be available, i$.$e$.$ Bob is not able to modify table structure.

Add Wendy as a login and user to the database and assign a secure password $($following Bob's Home Repair policy$).$

Configure Wendy's database access so she can:

View all data in all tables.

Insert supplier detail information $($rows$)$ to the suppliers table.

No other permissions are to be available.