INSERT INTO ENTERPRISE VALUES(1,'Mercury',8462756328);
INSERT INTO ENTERPRISE VALUES(2,'Altarix',8462116328);
INSERT INTO ENTERPRISE VALUES(3,'IBM',8462756111);
INSERT INTO ENTERPRISE VALUES(4,'Megafon',8462716328);
INSERT INTO ENTERPRISE VALUES(5,'Sberbank',8462256328);
INSERT INTO ENTERPRISE VALUES(6,'VTB-24',8462543328);
INSERT INTO ENTERPRISE VALUES(7,'Tinkoff-bank',8462776328);
INSERT INTO ENTERPRISE VALUES(8,'Vita',8462756312);
INSERT INTO ENTERPRISE VALUES(9,'Haulmount',84622334328);
INSERT INTO ENTERPRISE VALUES(10,'Apple',8888888888);

INSERT INTO EMPLOYEE VALUES(1,'Габрусевич Павел Евгеньевич',89650738240,'misefealaska@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(2,'Чугунов Евгений Александрович',89650711140,'kolobok@gmail.com',20);
INSERT INTO EMPLOYEE VALUES(3,'Харламов Ярослав Александрович',89990738240,'harlamov@gmail.com',24);
INSERT INTO EMPLOYEE VALUES(4,'Голов Максим Юрьевич',87656543211,'golov@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(5,'Каймаков Кирилл Сергеевич',89611738240,'kaymakov@gmail.com',20);
INSERT INTO EMPLOYEE VALUES(6,'Шепелев Федор Иванович',88888738240,'shepelev@gmail.com',20);
INSERT INTO EMPLOYEE VALUES(7,'Иванов Петр Петрович',89096756787,'ivanov@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(8,'Кузнецова Алина Юрьевна',81234234789,'mka@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(9,'Витина Екатерина Олеговна',88989765454,'oloi@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(10,'Мороз Елена Петровна',86754765456,'gendalf@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(11,'Орлова Анастасия Сергеевна',80987654321,'ska@gmail.com',21);
INSERT INTO EMPLOYEE VALUES(12,'Постафина Мария Серегеевна',89999876542,'feaka@gmail.com',21);

INSERT INTO Speciality VALUES(1,'Программист');
INSERT INTO Speciality VALUES(2,'Инженер');
INSERT INTO Speciality VALUES(3,'Менеджер');
INSERT INTO Speciality VALUES(4,'Преподаватель');
INSERT INTO Speciality VALUES(5,'Юрист');
INSERT INTO Speciality VALUES(6,'Экономист');

INSERT INTO RESUME VALUES(1,1,1,'12-07-17');
INSERT INTO RESUME VALUES(2,1,2,'12-06-17');
INSERT INTO RESUME VALUES(1,2,3,'12-08-17');
INSERT INTO RESUME VALUES(2,3,4,'22-12-17');
INSERT INTO RESUME VALUES(1,4,5,'12-07-17');
INSERT INTO RESUME VALUES(1,5,6,'10-05-17');
INSERT INTO RESUME VALUES(1,6,7,'12-06-17');
INSERT INTO RESUME VALUES(6,7,8,'11-07-17');
INSERT INTO RESUME VALUES(3,8,9,'11-07-17');
INSERT INTO RESUME VALUES(5,9,10,'11-07-17');

INSERT INTO VACANCY VALUES(1,1,50000,2,1);
INSERT INTO VACANCY VALUES(1,2,40000,2,6);
INSERT INTO VACANCY VALUES(2,3,60000,3,1);
INSERT INTO VACANCY VALUES(4,4,70000,2,1);
INSERT INTO VACANCY VALUES(5,5,40000,2,2);
INSERT INTO VACANCY VALUES(6,6,30000,2,1);
INSERT INTO VACANCY VALUES(3,7,20000,2,6);
INSERT INTO VACANCY VALUES(2,8,55000,2,4);
INSERT INTO VACANCY VALUES(7,9,58000,2,1);
INSERT INTO VACANCY VALUES(7,10,58000,2,3);

SELECT Vacancy.NAME FROM Vacancy
INNER JOIN Speciality ON Vacancy.speciality_id=Speciality.id
WHERE speciality.name='Программист';

SELECT VACANCY.NAME FROM Vacancy
INNER JOIN Enterprise ON Vacancy.ENTERPRISE_ID=Enterprise.ID
WHERE Enterprise.name='Mercury';

SELECT EMPLOYEE.FIO FROM Employee
INNER JOIN Resume ON Resume.EMPLOYEE_ID=Employee.ID
INNER JOIN Speciality ON Resume.SPECIALITY_ID=Speciality.ID
INNER JOIN Vacancy ON Vacancy.SPECIALITY_ID = Speciality.ID
WHERE Vacancy.name='Android-Разработчик';

SELECT Enterprise.name, COUNT(*) AS Numberr FROM Enterprise
INNER JOIN VACANCY ON VACANCY.ENTERPRISE_ID=Enterprise.ID
WHERE VACANCY.ID>0 OR VACANCY.ID < 1
GROUP BY Enterprise.Name;

SELECT Enterprise.name,Speciality.NAME FROM Enterprise
INNER JOIN VACANCY ON VACANCY.ENTERPRISE_ID=Enterprise.ID
INNER JOIN Speciality ON Vacancy.Speciality_ID=Speciality.ID;

INSERT INTO Emplyeeview VALUES (13,'Шмыкин Федор Геннадьевич',86786787678,'durak@gmail.com',19);
UPDATE EmplyeeView SET age=25
WHERE id=13;
INSERT INTO SpecialityView VALUES (7,'Маркетолог');
DELETE FROM SpecialityView
WHERE name='Маркетолог';


CREATE VIEW FiveView AS
SELECT Enterprise.name AS Firm, Speciality.NAME AS Special FROM Enterprise
INNER JOIN VACANCY ON VACANCY.ENTERPRISE_ID=Enterprise.ID
INNER JOIN Speciality ON Vacancy.Speciality_ID=Speciality.ID;

CREATE OR REPLACE VIEW ViewWithControl AS
SELECT *  FROM EMPLOYEE
WHERE age=21;



CREATE VIEW ViewWithCheck AS
SELECT * FROM  Resume
WHERE DATA BETWEEN '12.06.17' AND '22.12.17'
WITH CHECK OPTION;


CREATE SEQUENCE  "NEWUSER"."ID_EMP_SEQ"
MINVALUE 1
MAXVALUE 1000
INCREMENT BY 1
START WITH 14
NOCACHE
NOORDER
NOCYCLE;

CREATE OR REPLACE PROCEDURE Add_New_Employee(
Fio_em Varchar2,Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
BEGIN
INSERT INTO Employee VALUES(ID_EMP_SEQ.NEXTVAL,Fio_em,Phone_em,Email_em,Age_em,NameUser_em);
commit;
END;

BEGIN
Add_New_Employee('Ан Виктор Петрович',765453,'port@gmail.com',22,'NewUser');
END;

CREATE OR REPLACE PROCEDURE Update_Employee(Id_em NUMBER,Fio_em Varchar2,
Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Employee_Exist Varchar2(70);
BEGIN
SELECT FIO INTO Employee_Exist FROM EMPLOYEE
WHERE id=id_em;
IF Employee_Exist IS NOT NULL THEN
UPDATE EMPLOYEE SET FIO=Fio_em,Age=Age_em,Email=Email_em,
Phone=Phone_em,NameUser=NameUser_em WHERE Id=Id_em;
commit;
ELSE RAISE_APPLICATION_ERROR(-20001,'ПОЛЬЗОВАТЕЛЯ С ТАКИМ ID НЕ СУЩЕСТВУЕТ!');
END IF;
END;

EXECUTE Update_Employee(1,'Габрусевич Павел Евгеньевич',89650738240,'misefealaska@gmail.com',21,'NameUser');

CREATE OR REPLACE PROCEDURE Add_New_Employee(
Fio_em Varchar2,Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Fio_Already_Exist EXCEPTION;
Employee_Fio_Exist VARCHAR2(70);
BEGIN
SELECT FIO INTO Employee_Fio_Exist FROM EMPLOYEE WHERE FIO=Fio_em;
Raise Fio_Already_Exist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
INSERT INTO Employee VALUES(ID_EMP_SEQ.NEXTVAL,Fio_em,Phone_em,Email_em,Age_em,NameUser_em);
commit;
END;
WHEN Fio_Already_Exist THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Задайте другую фамилию');
RAISE_APPLICATION_ERROR(-20001,'Пользователь с такой фамилией уже существует!');
END;
END;

EXECUTE Add_New_Employee('Ан Виктор Петрович',765453,'port@gmail.com',22,'NewUser');

CREATE OR REPLACE PROCEDURE Update_Employee(Id_em NUMBER,Fio_em Varchar2,
Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Fio_Already_Exist EXCEPTION;
Employee_Fio_Exist VARCHAR2(70);
Employee_Exist Varchar2(70);
BEGIN
SELECT FIO INTO Employee_Exist FROM EMPLOYEE
WHERE id=id_em;
IF Employee_Exist IS NOT NULL THEN
BEGIN
SELECT FIO INTO Employee_Fio_Exist FROM EMPLOYEE WHERE FIO=Fio_em;
Raise Fio_Already_Exist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
UPDATE EMPLOYEE SET FIO=Fio_em,Age=Age_em,Email=Email_em,
Phone=Phone_em,NameUser=NameUser_em WHERE Id=Id_em;
commit;
END;
WHEN Fio_Already_Exist THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Задайте другую фамилию');
RAISE_APPLICATION_ERROR(-20001,'Пользователь с такой фамилией уже существует!');
END;
END;
ELSE RAISE_APPLICATION_ERROR(-20001,'ПОЛЬЗОВАТЕЛЯ С ТАКИМ ID НЕ СУЩЕСТВУЕТ!');
END IF;
END;

EXECUTE Update_Employee(1,'Габрусевич Павел Евгеньевич',89650738240,'misefealaska@gmail.com',21,'NameUser');

CREATE OR REPLACE PROCEDURE Delete_Enterprise_With_Vacancy(Deleted_Enterprise NUMBER)
IS
BEGIN
DELETE FROM VACANCY WHERE Id IN
(SELECT Id FROM Vacancy WHERE Enterprise_Id = Deleted_Enterprise);
DELETE FROM Enterprise WHERE Id = Deleted_Enterprise;
END;

EXECUTE Delete_Enterprise_With_Vacancy(3);

CREATE OR REPLACE PROCEDURE Delete_Speciality_With_Vacancy(Deleted_Speciality NUMBER)
IS
Curr_User VARCHAR(30);
BEGIN
SELECT USER
INTO Curr_User
FROM dual;
IF(Curr_User IN ('NEWUSER','SYS')) THEN
BEGIN
DELETE FROM VACANCY WHERE Id IN
(SELECT Id FROM Vacancy WHERE Speciality_Id = Deleted_Speciality );
DELETE FROM SPECIALITY WHERE Id = Deleted_Speciality;
END;
ELSE
Raise_Application_Error(-20001,'Вы не входите в список пользователей которым позволено выполнить данную операцию!');
END IF;
END;

CREATE OR REPLACE PROCEDURE Add_New_Employee(
Fio_em Varchar2,Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Curr_User VARCHAR(30);
Fio_Already_Exist EXCEPTION;
Employee_Fio_Exist VARCHAR2(70);
BEGIN
SELECT USER
INTO Curr_User
FROM dual;
IF(Curr_User IN ('NEWUSER','SYS')) THEN
BEGIN
SELECT FIO INTO Employee_Fio_Exist FROM EMPLOYEE WHERE FIO=Fio_em;
Raise Fio_Already_Exist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
INSERT INTO Employee VALUES(ID_EMP_SEQ.NEXTVAL,Fio_em,Phone_em,Email_em,Age_em,NameUser_em);
commit;
END;
WHEN Fio_Already_Exist THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Задайте другую фамилию');
RAISE_APPLICATION_ERROR(-20001,'Пользователь с такой фамилией уже существует!');
END;
END;
ELSE
Raise_Application_Error(-20001,'Вы не входите в список пользователей которым позволено выполнить данную операцию!');
END IF;
END;

CREATE OR REPLACE Package EmployeePackage IS
PROCEDURE Add_New_Employee(
Fio_em Varchar2,Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2);
 PROCEDURE Update_Employee(Id_em NUMBER,Fio_em Varchar2,
Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2);
END EmployeePackage;

CREATE OR REPLACE Package Body EmployeePackage IS
PROCEDURE Add_New_Employee(
Fio_em Varchar2,Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Fio_Already_Exist EXCEPTION;
Employee_Fio_Exist VARCHAR2(70);
BEGIN
SELECT FIO INTO Employee_Fio_Exist FROM EMPLOYEE WHERE FIO=Fio_em;
Raise Fio_Already_Exist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
INSERT INTO Employee VALUES(ID_EMP_SEQ.NEXTVAL,Fio_em,Phone_em,Email_em,Age_em,NameUser_em);
commit;
END;
WHEN Fio_Already_Exist THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Задайте другую фамилию');
RAISE_APPLICATION_ERROR(-20001,'Пользователь с такой фамилией уже существует!');
END;
END;
PROCEDURE Update_Employee(Id_em NUMBER,Fio_em Varchar2,
Phone_em NUMBER,Email_em Varchar2,Age_em NUMBER,NameUser_em Varchar2)
IS
Fio_Already_Exist EXCEPTION;
Employee_Fio_Exist VARCHAR2(70);
Employee_Exist Varchar2(70);
BEGIN
SELECT FIO INTO Employee_Exist FROM EMPLOYEE
WHERE id=id_em;
IF Employee_Exist IS NOT NULL THEN
BEGIN
SELECT FIO INTO Employee_Fio_Exist FROM EMPLOYEE WHERE FIO=Fio_em;
Raise Fio_Already_Exist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
UPDATE EMPLOYEE SET FIO=Fio_em,Age=Age_em,Email=Email_em,
Phone=Phone_em,NameUser=NameUser_em WHERE Id=Id_em;
commit;
END;
WHEN Fio_Already_Exist THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Задайте другую фамилию');
RAISE_APPLICATION_ERROR(-20001,'Пользователь с такой фамилией уже существует!');
END;
END;
ELSE RAISE_APPLICATION_ERROR(-20001,'ПОЛЬЗОВАТЕЛЯ С ТАКИМ ID НЕ СУЩЕСТВУЕТ!');
END IF;
END;
END EmployeePackage;

BEGIN
EmployeePackage.Add_New_Employee('Чугунов Денис',89650713330,'kolobok@gmail.com',18,'NameUser');
END;

CREATE  SEQUENCE ID_ENT_SEQ
MINVALUE 1
MAXVALUE 100
INCREMENT BY 1
START WITH 12
NOCACHE
NOORDER
NOCYCLE;

DROP SEQUENCE ID_ENT_SEQ;



CREATE OR REPLACE TRIGGER Trigger_Employee
BEFORE INSERT OR UPDATE ON Employee
FOR EACH ROW
BEGIN
IF(INSERTING) THEN
SELECT ID_EMP_SEQ.NEXTVAL
INTO   :NEW.ID
FROM   dual;
ELSIF(UPDATING AND :NEW.ID IS NULL) THEN
SELECT ID_EMP_SEQ.NEXTVAL
INTO   :NEW.ID
FROM   dual;
END IF;
END;

CREATE OR REPLACE TRIGGER Trigger_Enterprise
BEFORE INSERT OR UPDATE ON ENTERPRISE
FOR EACH ROW
BEGIN
IF(INSERTING) THEN
SELECT ID_ENT_SEQ.NEXTVAL
INTO   :NEW.ID
FROM   dual;
ELSIF(UPDATING AND :NEW.ID IS NULL) THEN
SELECT ID_ENT_SEQ.NEXTVAL
INTO   :NEW.ID
FROM   dual;
END IF;
END;



ALTER TRIGGER Trigger_Enterprise Enable;
ALTER TRIGGER Trigger_Employee Enable;
INSERT INTO ENTERPRISE (Name,Phone,NameUser) VALUES ('opencode',11111,'NameUser');
INSERT INTO Employee(FIO,PHONE,EMAIL,AGE,NAMEUSER) VALUES ('Габру Пав Евгеньевич',89650738240,'misefealaska@gmail.com',21,'Pablo');

CREATE  SEQUENCE Spec
MINVALUE 1
MAXVALUE 100
INCREMENT BY 1
START WITH 8
NOCACHE
NOORDER
NOCYCLE;
CREATE OR REPLACE TRIGGER Trigger_Spec
BEFORE INSERT OR UPDATE ON Speciality
FOR EACH ROW
BEGIN
IF(INSERTING) THEN
SELECT Spec.NEXTVAL
INTO   :NEW.ID
FROM   dual;
ELSIF(UPDATING AND :NEW.ID IS NULL) THEN
SELECT Spec.NEXTVAL
INTO   :NEW.ID
FROM   dual;
END IF;
END;
INSERT INTO Speciality(Name,NameUser) VALUES('Cleaning','NameUser');

CREATE TABLE EMPLOYEE_CHANGE
(CHANGE_NAME VARCHAR2(30),
 CHANGE_DATA DATE
);

CREATE OR REPLACE TRIGGER TRIGGER_AUDIT
AFTER INSERT OR UPDATE OR DELETE ON EMPLOYEE
FOR EACH ROW
BEGIN
IF (INSERTING)THEN
INSERT INTO EMPLOYEE_CHANGE VALUES('INSERT',SYSDATE);
ELSIF(UPDATING)THEN
INSERT INTO EMPLOYEE_CHANGE VALUES ('UPDATE',SYSDATE);
ELSIF (DELETING) THEN
INSERT INTO EMPLOYEE_CHANGE VALUES ('DELETE',SYSDATE);
END IF;
END;


CREATE OR REPLACE TRIGGER TRIGGER_EMPLOYEE
BEFORE INSERT OR UPDATE ON EMPLOYEE
FOR EACH ROW
DECLARE
FIO_ALREADY_EXIST EXCEPTION;
EMPLOYEE_EXIST VARCHAR2(30);
EMPLOYEE_FIO_EXIST VARCHAR(30);
BEGIN
SELECT FIO INTO EMPLOYEE_FIO_EXIST FROM EMPLOYEE
WHERE FIO = :NEW.FIO AND ROWNUM = 1;
RAISE FIO_ALREADY_EXIST;
EXCEPTION
 WHEN NO_DATA_FOUND THEN
 BEGIN
IF (INSERTING) THEN
SELECT ID_EMP_SEQ.NEXTVAL
INTO :NEW.ID
FROM DUAL;
ELSIF (UPDATING AND :NEW.ID IS NULL) THEN
SELECT ID_EMP_SEQ.NEXTVAL
INTO :NEW.ID
FROM DUAL;
END IF;
END;
WHEN FIO_ALREADY_EXIST THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('Придумайте другую фамилию');
RAISE_APPLICATION_ERROR (-20001,'Пользователь с такой фамилией уже существует');
END;
END;

INSERT INTO Resume VALUES (1,5,11,'11-03-17','Pic');
INSERT INTO Speciality (Name,NameUser) VALUES ('Monster','NewUser');

CREATE OR REPLACE TRIGGER TrigSpec
BEFORE INSERT ON Speciality
FOR each ROW
BEGIN
SELECT Spec.NEXTVAL
INTO   :NEW.ID
FROM   dual;
END;

INSERT INTO SPECIALITY (Name,NameUser)VALUES('MonstrTraki','NEWUSER');

CREATE OR REPLACE TRIGGER ViewTrigger
Instead OF UPDATE ON SecondView
FOR each ROW
BEGIN
INSERT INTO Vacancy VALUE(7,11,30000,3,3,'PHP-developer','pic');
END;

CREATE USER pasha IDENTIFIED BY pasha
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE TEMP;

GRANT CREATE SESSION TO pasha;

GRANT SELECT ON EMPLYEEVIEW TO pasha;
GRANT SELECT ON ENTERPRISEVIEW TO pasha;
GRANT SELECT ON SPECIALITYVIEW TO pasha;
GRANT SELECT ON VACANCYVIEW TO pasha;
GRANT SELECT ON RESUMEVIEW TO pasha;
GRANT SELECT ON FIRSTVIEW TO pasha;
GRANT SELECT ON SECONDVIEW TO pasha;
GRANT SELECT ON THIRDVIEW TO pasha;
GRANT SELECT ON FOURTHVIEW TO pasha;

GRANT EXECUTE ON EMPLOYEEPACKAGE TO pasha;

CONNECT pasha/pasha;
SELECT * FROM NEWUSER.EMPLYEEVIEW;
CONNECT pasha/pasha;
EXECUTE NEWUSER.EMPLOYEEPACKAGE.ADD_NEW_EMPLOYEE('Харитонов Ярослав',896507234130,'obok@gmail.com',28,'NameUser');

GRANT SELECT ON EMPLOYEE TO pasha;
GRANT SELECT ON ENTERPRISE TO pasha;
GRANT SELECT ON RESUME TO pasha;
GRANT SELECT ON VACANCY TO pasha;
GRANT SELECT ON SPECIALITY TO pasha;

GRANT INSERT ON EMPLOYEE TO pasha;
GRANT INSERT ON ENTERPRISE TO pasha;
GRANT INSERT ON RESUME TO pasha;
GRANT INSERT ON VACANCY TO pasha;
GRANT INSERT ON SPECIALITY TO pasha;

GRANT UPDATE ON EMPLOYEE TO pasha;
GRANT UPDATE ON ENTERPRISE TO pasha;
GRANT UPDATE ON RESUME TO pasha;
GRANT UPDATE ON VACANCY TO pasha;
GRANT UPDATE ON SPECIALITY TO pasha;

GRANT DELETE ON EMPLOYEE TO pasha;
GRANT DELETE ON ENTERPRISE TO pasha;
GRANT DELETE ON RESUME TO pasha;
GRANT DELETE ON VACANCY TO pasha;
GRANT DELETE ON SPECIALITY TO pasha;

INSERT INTO NEWUSER.EMPLOYEE VALUES(20,'Абдулов Алексей Геннадьевич',896507234130,'obok@gmail.com',28,'NameUser');

CONNECT NewUser/NewUser;


REVOKE SELECT ON EMPLYEEVIEW FROM pasha;
REVOKE SELECT ON ENTERPRISEVIEW FROM  pasha;
REVOKE SELECT ON SPECIALITYVIEW FROM  pasha;
REVOKE SELECT ON VACANCYVIEW FROM  pasha;
REVOKE SELECT ON RESUMEVIEW FROM  pasha;
REVOKE SELECT ON FIRSTVIEW FROM  pasha;
REVOKE SELECT ON SECONDVIEW FROM  pasha;
REVOKE SELECT ON THIRDVIEW FROM  pasha;
REVOKE SELECT ON FOURTHVIEW FROM  pasha;

REVOKE SELECT ON EMPLOYEE FROM pasha;
REVOKE SELECT ON ENTERPRISE FROM pasha;
REVOKE SELECT ON RESUME FROM pasha;
REVOKE SELECT ON VACANCY FROM pasha;
REVOKE SELECT ON SPECIALITY FROM pasha;

REVOKE INSERT ON EMPLOYEE FROM pasha;
REVOKE INSERT ON ENTERPRISE FROM pasha;
REVOKE INSERT ON RESUME FROM pasha;
REVOKE INSERT ON VACANCY FROM pasha;
REVOKE INSERT ON SPECIALITY FROM pasha;

REVOKE DELETE ON EMPLOYEE FROM pasha;
REVOKE DELETE ON ENTERPRISE FROM pasha;
REVOKE DELETE ON RESUME FROM pasha;
REVOKE DELETE ON VACANCY FROM pasha;
REVOKE DELETE ON SPECIALITY FROM pasha;

REVOKE UPDATE ON EMPLOYEE FROM pasha;
REVOKE UPDATE ON ENTERPRISE FROM pasha;
REVOKE UPDATE ON RESUME FROM pasha;
REVOKE UPDATE ON VACANCY FROM pasha;
REVOKE UPDATE ON SPECIALITY FROM pasha;

disconnect NewUser;
CONNECT pasha/pasha;
SELECT * FROM NEWUSER.EMPLOYEE;
SELECT * FROM NEWUSER.ENTERPRISEVIEW;
INSERT INTO NEWUSER.EMPLOYEE VALUES (21,'Афиногенов Петр Ильич',896507234130,'obok@gmail.com',28,'NameUser');