Question: Exercise 17-2 [20 points] Write a script that (1) creates a login ID named RobertHalliday with the password HelloBob; (2) sets the default database for

Exercise 17-2 [20 points] Write a script that (1) creates a login ID named RobertHalliday with the password HelloBob; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named RobertHalliday for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1.

The script is what you're creating

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write a script that (1) creates a login ID named RobertHalliday with the password HelloBob; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named...

Exercise 17-6 [20 points] 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...

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...

Write a script that (1) creates a login ID named "Fall2022" with the password "12345678"; (2) sets the default database for the login to the AP database; (3) creates a user named "James" for the...

Chapter 1 7 How to manage database security Exercises 1 . Write a script that creates a user - defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission...

1. 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...

1. 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...

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...

1. Write a script that a. creates a server login ID named "AmalB with the password "aaar999" b. sets the default database for the login to the AP database c. sets check policy to off d. creates a...

1 . Write a script that creates a user - defined database role named PaymentEntry in the AP database. Give UPDATE permission to the new role for the Invoices table, UPDATE and INSERT permission for...

Referring to Exercise 6.1.30, find the variance for the number of boxes of Wheaties bought before getting half of the players pictures and the variance for the number of additional boxes needed to...

A fluid exerts an upward buoyancy force on an object immersed in it. In the derivation of Eq. (5.9) the buoyancy force exerted on an object by the fluid was ignored. But in some situations, where the...

Jefferson Inc.s accountants use their sophisticated knowledge of the companys cost behaviors, such as variable, fixed, mixed, semi-variable, and step costs, to build statistical models regarding the...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) International Studies Using the Internet, compare the value of the dollar to the value of worldwide currencies. Find the value of the Japanese yen, British pound, Chinese yuan, Euro,...

(Appendices) A luncheon speaker stated, most firms have a strong financial incentive to reduce occupational injuries because the indirect costs of workplace accidents can exceed the employers direct...

(Appendices) Research Perform research to find a recent news story about a business that used deceptive marketing practices, such as price fixing, bait and switch, fake sales, low-balling, or another...