PROCEDURE $1$: Write SQL query script that creates a user$-$defined database role named USER$\_$B in the WideWorldImporters database. Give ALTER and INSERT permission to the new role for the InvoiceLines table in Sales Schema, UPDATE and INSERT permission for the PurchaseOrderLines table in Purchasing Schema and SELECT permission for the table Cities in Application schema $(50$ Points$).$

PROCEDURE $2$: Write a script that $(1)$ creates a login ID named "Login$\_$B$"$ with the password "login$1111"$; $(2)$ gives the user access to the WideWorldImporters database; and $(3)$ assigns the user to the USER$\_$B role you created in Procedure $1(30$ POINTS$).$

PROCEDURE $3$: Write a script that removes the user$-$defined database role named USER$\_$B $(20$ Points$).$