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.
A.
Contained databases
B.
Application roles
C.
Cross-database ownership chaining
D.
Digital certificates
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.
Application Roles
C. Cross-database ownership chaining
The owner of the table and the owner of the SP just need to bee the same and it will work, without granting any access.