subject

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?

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 08:40
What are the three parts to physical security standards for various types of army equipment and the risk level
Answers: 2
question
Computers and Technology, 23.06.2019 06:30
Which option correctly describes a dbms application? a. software used to manage databases b. software used to organize files and folders c. software used to develop specialized images d. software used to create effective presentations
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
The computers in the sales department did not have enough data storage capacity to contain all the information the department needed to store, and it was taking a long time for team members to access the data they needed. to fix the problem, the technician installed new, larger hard drives on all the computers.
Answers: 1
question
Computers and Technology, 23.06.2019 21:20
In microsoft word, when you highlight existing text you want to replace, you're in              a.  advanced mode.    b.  automatic mode.    c.  basic mode.    d.  typeover mode
Answers: 1
You know the right answer?
You administer a sql 2012 serve r that contains a database named salesdb. salesdb contains a schema...
Questions
question
Mathematics, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00
question
History, 02.11.2020 05:00
question
Chemistry, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00
question
Mathematics, 02.11.2020 05:00