Business > CASE STUDY > HW7-530.docx HW7 Advanced Database Management System Module 5: HW7 1. Write a script t (All)
HW7-530.docx HW7 Advanced Database Management System Module 5: HW7 1. Write a script t
Document Content and Description Below
HW7-530.docx HW7 Advanced Database Management System Module 5: HW7 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 Invoices table. Update and insert permission for the InvoiceLineItems table and SELECT permission for all the user tables. CODE: CREATE ROLE PaymentEntry; GRANT SELECT TO PaymentEntry; GRANT UPDATE ON Invoices TO PaymentEntry; GRANT INSERT, UPDATE ON InvoiceLineItems TO PaymentEntry; SCREENSHOT: 2. Write a script that (1) creates a login ID named œAAaron with the password œaaar9999 . (2) sets the default database for the login to the AP database. (3) creates a user named œAaron for the login. And (4) Assign the user to the PaymentEntry role you created in Exercise 1. CODE: USE AP; CREATE LOGIN AAaron WITH PASSWORD = 'aaar9999', DEFAULT_DATABASE = AP; CREATE USER Aaro. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]
Last updated: 2 years ago
Preview 1 out of 9 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$10.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jul 22, 2021
Number of pages
9
Written in
Additional information
This document has been written for:
Uploaded
Jul 22, 2021
Downloads
0
Views
83
