1. Using the Management Studio, create a login ID named RBrautigan with the password RBra9999, and set the default database to the MyGuitarShop database. Then, grant the login ID access to the MyGuitarShop database, create a user for the login ID named RBrautigan, and assign the user to the OrderEntry role you created in exercise 1. Note: If you get an error that says The MUST_CHANGE option is not supported, you can deselect the Enforce password policy option for the login ID.

For this exercise you will be submitting two screen captures showing that your changes were made.

2. Write a script that removes the user-defined database role named OrderEntry. (Hint: This script should begin by removing all users from this role.)

3. Write a script that (1) creates a schema named Admin, (2) transfers the table named Addresses from the dbo schema to the Admin schema, (3) assigns the Admin schema as the default schema for the user named RobertHalliday that you created in exercise 2, and (4) grants all standard privileges except for REFERENCES and ALTER to RobertHalliday for the Admin schema.