Computers and Technology

You administer a sql 2012 serve r that contains a database named salesdb. salesdb contains a schema named customers that has a table named regions. a user named usera is a member of a role named sales. usera is granted the select permission on the regions table. the sales role is grante d the select permission on the customers schema. you need to remove the select permission for usera on the regions table. you also need to ensure that usera can still access all the tables in the customers schema, including the regions table, through the sales role permissions. which transact-sql statement should you use?

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 01:30, winstonbendariovvygn
1. which of the following is a search engine? a) mozilla firefox b)internet explorer c)google d)safari 2. which of the following statements is true? a) all search engines will provide the same results when you enter the same query. b) all search engines use the same amount of advertisements. c) some search engines are also browsers. d) search engines often provide different results, even when you enter the same query.
Answers: 2
image
Computers and Technology, 23.06.2019 03:50, nakeytrag
Iam a bacterium. i cause stomach cramps and diarrhea. i am caused by eating rotten foodssuch as chicken, fish, or eggs. sometimes turtles carry my bacteria. what am i?
Answers: 2
image
Computers and Technology, 23.06.2019 12:00, trippie4life
3. when you right-click a linked spreadsheet object, what commands do you choose to activate the excel features? a. linked worksheet object > edit b. edit data > edit data c. linked spreadsheet > edit d. object > edit data
Answers: 2
image
Computers and Technology, 24.06.2019 01:00, cheycheybabygirl01
How can the temperature of a room be raised by 5degreesf?
Answers: 1
Do you know the correct answer?
You administer a sql 2012 serve r that contains a database named salesdb. salesdb contains a schema...

Questions in other subjects: