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?

Question

Accepted Answer

C. Create a stored procedure to modify data

Answer

A. Create a user-defined function to modify data.

Answer

B. Create a RULE on both the columns.

Answer

D. Create a CHECK constraint on both the columns.

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…

Question

Options

How the community answered

Community Discussion