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, 23.06.2019 07:00
To produce a starlight effect in her photograph, lina should choose the filter for her camera.
Answers: 1
question
Computers and Technology, 23.06.2019 09:00
The first screen you see when you open word2016 what is called?
Answers: 1
question
Computers and Technology, 23.06.2019 23:00
Lucas put a lot of thought into the design for his company's new white paper. he made sure to include repeating design elements such as color schemes and decorative images. his goal was to a.add symmetry b.create a unified publication c.provide consistency d.save money
Answers: 1
question
Computers and Technology, 24.06.2019 18:10
Most information security incidents will occur because of select one: a. users who do not follow secure computing practices and procedures b. increases in hacker skills and capabilities c. poorly designed network protection software d. increasing sophistication of computer viruses and worms
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
Advanced Placement (AP), 17.12.2021 02:40
question
Mathematics, 17.12.2021 02:40
Questions on the website: 13722363