Microsoft
70-459 · Question #123
You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2. You need to…
The correct answer is B. Application roles. An application role is a database principal that enables an application to run with its own, user- like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. Unlike database roles…
Design and implement database security
Question
You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2. You need to recommend a solution to ensure that SProc1 can access Table2 without granting users direct access to Table2. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- AContained databases
- BApplication roles
- CCross-database ownership chaining
- DDigital certificates
How the community answered
(33 responses)- A9% (3)
- B70% (23)
- C3% (1)
- D18% (6)
Explanation
An application role is a database principal that enables an application to run with its own, user- like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. Unlike database roles, application roles contain no members and are inactive by default.
Topics
#application roles#cross-database access#stored procedures#access control
Community Discussion
No community discussion yet for this question.