Question: 1 . Write a script that creates a user - defined database role named PaymentEntry in the AP database. Give UPDATE permission to the new

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 the InvoiceLineItems table, and SELECT permission for all user tables.

2 .

Write a script that

(1)

creates a login ID named "AAaron" with the password "aaar

999 "

;

(2)

sets the default database for the login to the AP database;

(3)

creates a user named "Aaron" for the login; and

(4)

assigns the user to the PaymentEntry role you created in exercise

1 . 4 .

Using the Management Studio, create a login ID named "FFalk" with the password "ffal

9999 ",

and set the default database to the AP database. Then, create a user for the login ID named "FFalk" and assign the user to the PaymentEntry role you created in exercise

1 .

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!

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

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

Database Security Lab Unit 7 Lab Exercise 1 Write a script that creates a user - defined database role in the AP database. Name this new role PaymentEntryXX where the XX are your initials. Give...

1. Write a script that uses the XML document shown below to update the contact information in the Vendors table. Stanley Henry Ono Santa 2. Pick all that apply. Write a script that Creates a...

Write a script that Creates a user-defined database role name PaymentEntry in the AP database. Give Update permission to the new role for the Invoices table. Give Update and Insert permission for the...

Mary is concerned with evaluating her business based on the break-even point. Last year, in her business with 550 sales (all of the same product), she had the following annual expenses : Salary (flat...

You have been hired as a telephone sales representative at a very large travel agency. In this job, when customers call to book holidays you look up airline flights, times, and fares on the computer...

A saver who expects to have a higher tax rate after retirement would prefer a _ _ _ _ _ _ _ _ _ _ . Question 2 0 options: Roth retirement plan traditional retirement plan 4 0 1 k plan 4 0 3 b plan

Define a function that takes two integers x and k as parameters. The function should divide x into k (mostly) equal integers and combine each of these integers into a list. The function should return...

At 50 per box, our std. contract forms are $9 a box, and our warranty forms are $7.95 a box.

Whenever you can come, professor, our employees will greatly enjoy your presentation.

She received her master of business administration degree from the university of michigan.