You need to grant Robery permission to modify employee phone numbers in the Employees table, but you do not want him to be able to modify any other data in the table. Select the best way to accomplish this.

You need to grant Robery permission to modify employee phone numbers in the Employees table, but you do not want him to be able to modify any other data in the table. Select the best way to accomplish this.

You need to grant Robery permission to modify employee phone numbers in the Employees table, but you do not want him to be able to modify any other data in the table. Select the best way to accomplish this.


Answer: -  Create a stored procedure to change the phone number, and grant Robert Execute permission on the stored procedure.

(Column-level permissions are possible in SQL Server, but they are hard to maintain, and rarely the answer to security problems. You could use a view, but it is not usually best to create a view for just a single column. Creating a stored procedure and granting Robert Execute permission is the best way to fix this issue.)