subject

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 "aaar999"; (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 exercise1.

4. using the management studio, create a login id named "ffalk" with the password "ffal", 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 exercise1.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 03:00
Jason, samantha, ravi, sheila, and ankit are preparing for an upcoming marathon. each day of the week, they run a certain number of miles and write them into a notebook. at the end of the week, they would like to know the number of miles run each day, the total miles for the week, and average miles run each day. write a program to them analyze their data. your program must contain parallel arrays: an array to store the names of the runners and a two-dimensional array of five rows and seven columns to store the number of miles run by each runner each day. furthermore, your program must contain at least the following functions: a function to read and store the runners’ names and the numbers of miles run each day; a function to find the total miles run by each runner and the average number of miles run each day; and a function to output the results. (you may assume that the input data is stored in a file and each line of data is in the following form: runnername milesday1 milesday2 milesday3 milesday4 milesday5 milesday6 milesday7.)
Answers: 3
question
Computers and Technology, 23.06.2019 09:30
Name the range function that would generate the following list of integers values: 0,1,2,3,4,5.
Answers: 1
question
Computers and Technology, 23.06.2019 14:30
Open this link after reading about ana's situation. complete each sentence using the drop-downs. ana would need a minimum of ato work as a translator. according to job outlook information, the number of jobs for translators willin the future.
Answers: 3
question
Computers and Technology, 24.06.2019 18:20
Acommon algorithm for converting a decimal number to binary is to repeatedly divide the decimal number by 2 and save the remainder. this division is continued until the result is zero. then, each of the remainders that have been saved are used to construct the binary number.write a recursive java method that implements this algorithm.it will accept a value of int and return a string with the appropriate binary character representation of the decimal number.my code: public class lab16{public string converttobinary(int input){int a; if(input > 0){a = input % 2; return (converttobinary(input / 2) + "" +a); } return ""; } }
Answers: 1
You know the right answer?
Write a script that creates a user-defined database role named paymententry in the ap database. give...
Questions
question
Mathematics, 19.05.2020 14:10
question
English, 19.05.2020 14:10
question
Mathematics, 19.05.2020 14:10
question
English, 19.05.2020 14:10
question
English, 19.05.2020 14:10
Questions on the website: 13722360