Question: 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

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.

Must be done with Microsoft SQL Server Mangement

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!

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

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

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

creates a login ID named "CIS435_user1" with the password "P@ssword1"; (2) sets the default database for the login to the AdventureWorks2012 database; (3) creates a user named "CIS435_user1" for the...

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

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

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

Read the mini case Russian Ruble Roulette and write a summary of it.

In a family with 3 children, excluding multiple births, what is the probability of having 2 boys and 1 girl, in any order? Assume that a boy is as likely as a girl at each birth.

Bethany Corporation is considering purchasing new equipment that will have a project life of 5 years and an initial cost of $ 5 0 0 , 0 0 0 . The new equipment is estimated to improve the quality of...

An individual who goes short in a futures position has the _ _ _ _ _ _ _ _ _ _ . A . right to deliver the underlying commodity at contract maturity B . obligation to purchase the underlying commodity...

identify potential ethical and environmental issues about pay and reward.

explain the importance of developing a pay and reward strategy for an organisation

2. Interview managers or employees from three organisations of your choice from different industrial sectors to establish what effect, if any, the introduction of the living wage has or would have on...