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

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 default schema for the user named RobertHalliday that you created in exercise 2, and (4) grants all standard privileges except for REFERENCES and ALTER to RobertHalliday for the Admin schema.

Language is SQL Server Management Studio (SQL Server Express 2017)

Here is exercise 2: 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!

Use Microsoft SQL Server Management Studio 17 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...

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 default schema for the user...

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

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

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

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Exercise 5: (20 points) Write a 200 words research paragraph about: " Applications of matrices" - Your paragraph should be well organized with appropriate format and relevant content. (10 points) -...

Exercise 1. [20 points] Write a C++ program that implements the classes whose UML diagrams are given below: - Rectangle and Triangle classes should inherit from Shape, which only has the area()...

What questions should be asked after a returned item has been counted and recorded?

Big Apple Investment Bankers offers Northern Diagnostics the following options on its initial public sale of equity: (1) a best-efforts arrangement whereby Big Apple will keep 2 % of the retail sales...

1 A project requires an initial investment of $ 2 5 0 , 0 0 0 . It generates annual revenues of $ 1 5 0 , 0 0 0 and operating costs of $ 6 0 , 0 0 0 . The project lasts for 4 years and is depreciated...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Calculate total-revenue data from the demand schedule in question

Graph total revenue below your demand curve. Generalize about the relationship between price elasticity and total revenue.

KEY QUESTION How would the following changes in price affect total revenue? That is, would total revenue increase, decline, or remain unchanged? a. Price falls and demand is inelastic. b. Price rises...