Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Security Lab Unit 7 Lab Exercise 1 Write a script that creates a user - defined database role in the AP database. Name this
Database Security Lab
Unit Lab Exercise
Write a script that creates a userdefined 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:
PaymentEntryXX Role Creation Script
Coded by: Your Name
Coded on: MMDDYY
Paste below this line the Script you wrote for this exercise
Paste here
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started