Question

A table Employee consists of fields Employee No, Name, Designation and Salary. Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him.

1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. 

2. Write SQL query for implementing this

Answer 1

1. Views 

2. Create view Empview as select employee no, Name, Designation from Employee.