A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?


A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column?


A. Using a view to access the table

B. Using a referential constraint on the table

C. Revoking access from the phone_number column

D. Defining a table check constraint on the table


Questions by suvidha

Showing Answers 1 - 7 of 7 Answers

i_virus

  • Sep 12th, 2008
 

One can create a VIEW on the EMPLOYEE table having all the columns except the phone_number column and then allow users to access only to the view.

Sample Query:

CREATE VIEW AS EMP
 SELECT name, department FROM EMPLOYEE;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions