USE MICROSOFT SQL SERVER 22Murach's SQL Server 2016 for Developers: My Guitar Shop exercises (modified)Chapter 17How to manage database securityExercises1 Write a script that creates a user-defined database role named OrderEntry in theMyGuitarShop database. Give INSERT and UPDATE permission to the new role forthe Orders and OrderItems table. Give SELECT permission for all user tables.2 Write a script that (1) creates a login ID named "BillyHalliday" with the password"HelloBilly"; (2) sets the default database for the login to the MyGuitarShopdatabase; (3) creates a user named "BHalliday" for the login; and (4) assigns the userto the OrderEntry role you created in exercise 1.3 Write a script that uses dynamic SQL and a cursor to loop through each row of theAdministrators table and (1) create a login ID for each row that consists of theadministrator's last and first name with no space between; (2) set a temporarypassword of "dump" for each login; (3) set the default database for the login to theMyGuitarShop database; (4) create a user for the login with the same name as thelogin; and (4) assign the user to the OrderEntry role you created in exercise 1.4 Using the Management Studio, create a login ID named "ASmithfield" with thepassword "ASmi9999," and set the default database to the MyGuitarShop database.Then, grant the login ID access to the MyGuitarShop database, create a user for thelogin ID named "RBrautigan", and assign the user to the OrderEntry role you createdin 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.Save a screen print of the user list after adding this user. Name it ex17-04a.png.(Any image format will be fine)5Write a script that removes the user-defined database role named OrderEntry. (Hint:This script should begin by removing all users from this role.)6Write a script that (1) creates a schema named Admin, (2) transfers the table namedAddresses from the dbo schema to the Admin schema, (3) assigns the Admin schemaas the default schema for the user named RobertHalliday that you created in exercise2, and (4) grants all standard privileges except for REFERENCES and ALTER toRobert Halliday for the Admin schema. AdministratorsAdmin DEmailAddressPasswordFirstNameLastNameOrderitemsItem DOrder D7ProductsProductIDCategoryIDProduct CodeProductNameDescriptionListPriceProductIDItemPriceCategoriesCategoryIDDiscountAmountQuantityDiscountPercentDate AddedCategoryNameQAddressesAddressIDCustomerlDLinelLine2CityStateZipCodePhoneDisabledOrders8OrderIDCustomerlDOrderDateShipAmountTaxAmountShipDateShipAddressIDCard TypeCardNumberCardExpiresBillingAddressIDCustomersCustomer DEmailAddressPasswordFirstNameLastNameShippingAddressIDBillingAddress D

Please find the attached solution of the given problem:

Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give SELECT permission for all user tables. Write a script that (1) creates a login ID named "BillyHalliday" with the password "HelloBilly"; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named "BHalliday" for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1.