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 UPDATE permission to the new role for the

Invoices table, UPDATE and INSERT permission for the Invoicelineltems table, and SELECT

permission for all user tables. Make sure to include a comment at the top of the script with

your name and the date you coded the script. Format this comment like the following sample:

$/************************************************************************************************************************************\frac{*}{?}$

$/*$ PaymentEntryXX Role Creation Script $*/$

$/*$ Coded by: Your Name $*/$

$/*$ Coded on: MM$/$DD$/$YY $*/$

$---$ Paste below this line the Script you wrote for this exercise $--$

Paste here