subject

You administer a sql server 2012 server 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 granted the
select permission on the customers schema.
you need to ensure that usera is disallowed to select from any of the tables in the
customers schema.
which transact-sql statement should you use?
a. deny select on object: : regions from usera
b. deny select on object: : regions from sales
c. deny select on schema: : customers from usera
d. revoke select on schema: : customers from sales
e. revoke select on schema: : customers from usera
f. revoke select on object: : regions from sales

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:00
Write a program which asks you to enter a name in the form of first middle initial last. so you might enter for example samuel p. clemens. use getline to read in the string because it contains spaces. also, apparently the shift key on your keyboard doesn’t work, because you enter it all lower case. pass the string to a function which uses .find to locate the letters which need to be upper case and use toupper to convert those characters to uppercase. the revised string should then be returned to main in the form last, first mi where it will be displayed.
Answers: 1
question
Computers and Technology, 22.06.2019 18:00
Which of the following physical laws can make the flow of water seem more realistic? a. motion b. gravity c. fluid dynamics d. thermodynamics
Answers: 2
question
Computers and Technology, 23.06.2019 01:50
Free points just awnser this. what should i watch on netflix
Answers: 2
question
Computers and Technology, 23.06.2019 17:30
Per the municipal solid waste report, what are the most common sources of waste (trash
Answers: 3
You know the right answer?
You administer a sql server 2012 server that contains a database named salesdb.
salesdb contai...
Questions
question
Health, 18.10.2020 23:01
question
Physics, 18.10.2020 23:01
question
Mathematics, 18.10.2020 23:01
question
Mathematics, 18.10.2020 23:01
question
Mathematics, 18.10.2020 23:01
question
English, 18.10.2020 23:01
question
Spanish, 18.10.2020 23:01
question
Computers and Technology, 18.10.2020 23:01
question
Mathematics, 18.10.2020 23:01
Questions on the website: 13722367