MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What permission enables a user to change the definition of a stored procedure?

A	CHANGE
B	CHANGE DEFINITION
C	ALTER
D	None of the above

Explanation:

Detailed explanation-1: -Use SQL Server Management Studio Expand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure to grant permissions on, and then select Properties.

Detailed explanation-2: -To grant permissions on a stored procedure Expand Stored Procedures, right-click the procedure to grant permissions on, and then select Properties. From Stored Procedure Properties, select the Permissions page. To grant permissions to a user, database role, or application role, select Search.

Detailed explanation-3: -Requires CREATE PROCEDURE permission in the database and ALTER permission on the schema in which the procedure is being created.

Detailed explanation-4: -ALTER PROCEDURE does not change permissions and does not affect any dependent stored procedures or triggers.

There is 1 question to complete.