Figure 6: View example

CREATE TABLE emp_tab
  (empid INTEGER, empname VARCHAR(30), empsalary DECIMAL(9,2));
CREATE VIEW empview AS
   SELECT empid, empname FROM emp_tab;
REVOKE ALL ON emp_tab FROM user1;
GRANT INSERT,UPDATE,DELETE,SELECT ON empview TO user1;

CREATE VIEW empview_hr AS
   SELECT empid, empname,empsalary FROM emp_tab;
REVOKE ALL ON emp_tab FROM hruser1;
GRANT INSERT, UPDATE, DELETE, SELECT ON empview TO hruser1