PrepAway - Latest Free Exam Questions & Answers

Tag: permission to allow user to create sp in sql 2008

Which two permissions will you require to perform this task?

You are the database administrator of your company. The network contains an instance of SQL Server 2008. Thenetwork also contains a Web server that hosts a Web application to provide product information to customers.The product information is stored in a database named Products on the SQL server. You want to create a stored procedure for use by the Web application that will return information about productsfrom the Products database that matches the search criteria specified by the customer.
Which two permissions will you require to perform this task? (Choose two. Each correct answer represents a partof the solution.)