You work as a Database Administrator for ABC Inc.

Vendor: GIAC
Product: GSSP-.NET
Update on: Jul 25, 2025
Questions: 491

GIAC GSSP-.NET Question Answer

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?

Create a user-defined function to modify data.

Create a RULE on both the columns.

Create a stored procedure to modify data

Create a CHECK constraint on both the columns.