CREATE VIEW V_NHANVIEN
AS
SELECT MADA,TENDA,PHONGCHUTRI,TRUONGDA FROM DUAN_1312508_1312474;
GRANT SELECT ON V_NHANVIEN TO ROLE_NHANVIEN;

CREATE OR REPLACE FUNCTION TEST_TRUONGDA(P_SCHEMA VARCHAR2, P_OBJ VARCHAR2)
RETURN VARCHAR2
AS
  USER VARCHAR2(100);  
BEGIN 
   IF (SYS_CONTEXT('USERENV', 'ISDBA') = 'TRUE') THEN 
	  RETURN '';
	ELSE
	  USER:=SYS_CONTEXT('USERENV', 'SESSION_USER');     
    RETURN 'DUAN IN(SELECT MADA FROM DUAN_1312508_1312474 WHERE TRUONGDA = '||USER||');';
	END IF;
END;
  
  BEGIN 
  DBMS_RLS.ADD_POLICY(
  object_schema => 'HQTCSDL_1312474_1312508',
  object_name => 'CHITIEU_1312508_1312474',
  policy_name => 'p_CHITIEU',
  function_schema => 'HQTCSDL_1312474_1312508',
  policy_function => 'TEST_TRUONGDA',
  statement_types => 'SELECT,UPDATE, INSERT',
  update_check => TRUE);
  END;