You administer a Microsoft SQL Server database that has Trustworthy set to On. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access to execute the stored procedure. You need to ensure that the stored procedure returns the required information when User1 executes the stored procedure. You need to achieve this goal by granting the minimum permissions required. Which two actions should you perform? Each correct answer presents part of the solution.

A. Grant the VIEW SERVER STATE permission to User1.
B. Move the stored procedure to the User1 schema.
C. Modify the stored procedure to include the EXECUTE AS OWNER statement. Grant VIEW SERVER STATE permissions to the owner of the stored procedure.
D. Grant the db_datareader role on the database to User1.
E. Create a SQL Server login that has VIEW SERVER STATE permissions. Modify the stored procedure to include the EXECUTE AS (newlogin) statement.

  Discussion forum

Question
0

Leave an answer