CW7-530.docx CW7 Advanced Database Management System Module 5: CW7 1. Using the SQL Se

Document Content and Description Below

CW7-530.docx CW7 Advanced Database Management System Module 5: CW7 1. Using the SQL Server Management Studio (SSMS), 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 problem #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. (#4 share the .PNG screenshot of SSMS also for this submission.) CODE: USE MyGuitarShop; CREATE LOGIN RBrautigan with password = 'RBra9999', DEFAULT_DATABASE = MyGuitarShop; CREATE USER RBrautigan FOR LOGIN RBrautigan; ALTER ROLE OrderEntry ADD MEMBER RBrautigan; SCREENSHOT: 2.Write a script . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]

Last updated: 1 year ago

Preview 1 out of 4 pages