question archive Database SQL Scripts with the database my sql server start by creating the server 1)Creating a Script 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 database user named "Amal" for the server login
Database SQL Scripts with the database my sql server start by creating the server 1)Creating a Script 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 database user named "Amal" for the server login
Subject:Computer SciencePrice: Bought3
Database SQL Scripts
with the database my sql server start by creating the server
1)Creating a Script
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 database user named "Amal" for the server login.
Use 'USE master' for creating the login ID and use 'USE AP' for creating the database user.
2) Creating Script
a) creates a user-defined database role named PaymentEntry in the AP database
b) provides the following permissions to the role
UPDATE permission for the Invoices table
UPDATE and INSERT permission for the InvoiceLineItems table
SELECT permission for all tables in the AP database
c) Assign the database user created earlier to the PaymentEntry role
3) Creating Script to remove the user-defined database role named PaymentEntry. Remember
to remove all users from the role before removing the role.
