Home » Microsoft » 70-461 v.2 » Which four statements should you execute in sequence?
DRAG DROP
You have a SQL Server database named CUSTOMERS.
You need to sign a stored procedure named SelectCustomers in the CUSTOMERS database.
Which four statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
There are four steps involved in signing a module:
1. Create a certificate using the Transact-SQL CREATE CERTIFICATE [certificateName] statement. This statement has several options for setting a start and end date and a password. The default expiration date is one year
2. Create a database user associated with that certificate using the Transact-SQL CREATE USER [userName] FROM CERTIFICATE [certificateName] statement. This user exists in the database only and is not associated with a login.
3. Grant the certificate user the required permissions on the database objects.
4. Sign the procedure with the certificate using the Transact-SQL ADD SIGNATURE TO [procedureName] BY CERTIFICATE [certificateName] statement.
References:https://msdn.microsoft.com/en-us/library/bb669102(v=vs.l 10).aspx