New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

GIAC GIAC Secure Software Programmer - C#.NET GSSP-NET-CSHARP Question # 11 Topic 2 Discussion

GIAC GIAC Secure Software Programmer - C#.NET GSSP-NET-CSHARP Question # 11 Topic 2 Discussion

GSSP-NET-CSHARP Exam Topic 2 Question 11 Discussion:
Question #: 11
Topic #: 2

You work as a Database Administrator for ABC Inc. The company has a SQL Server 2000 computer. One of the databases on the server contains a table named Employees, for storing information about employees in the company. There are two employees, Joe and Rick, to whom you want to give additional responsibilities. You want Joe to be allowed to modify only the E-mail column of the table, and Rick should be allowed to modify only the Salary column of the table. Neither Joe nor Rick should be allowed to have permission on the Employees table.

You want to ensure that the above rule is followed strictly. What will you do to accomplish this?


A.

Create a user-defined function to modify data.


B.

Create a RULE on both the columns.


C.

Create a stored procedure to modify data


D.

Create a CHECK constraint on both the columns.


Get Premium GSSP-NET-CSHARP Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.