SET NAMES WIN1251;
SET SQL DIALECT 3;

CONNECT 'localhost:test3' USER 'SYSDBA' PASSWORD 'masterkey';

SET AUTODDL ON;
set term ^ ;


create or alter procedure EXPORT_EMPLOYEES (
    NUM integer)
returns (
    EMPLOYEE_NUM integer)
AS
begin
    EMPLOYEE_NUM = NUM * 10;
    suspend;
end
^


CREATE OR ALTER VIEW VIEW_EMPLOYEES(
    EMPLOYEE_NUM_FROM_VIEW)
AS
select EMPLOYEE_NUM from EXPORT_EMPLOYEES(1)
^

set term ^ ;

grant execute on procedure EXPORT_EMPLOYEES to view VIEW_EMPLOYEES;
grant all on VIEW_EMPLOYEES to STATISTIC;
commit;



CONNECT 'localhost:test3' USER 'STATISTIC' PASSWORD 'status';

select * from VIEW_EMPLOYEES;
commit;

select * from EXPORT_EMPLOYEES( 1 );
commit;