[ 권한 및 시노님 ] 시스템공통으로 사용할 패키지에 대한 권한 및 시노님을 부여합니다.

-- ------------------------------------------------------------------------------------------------
conn bsys/1234@ndb;
-- 시노님 생성
create or replace synonym apex_error    for apex_230200.apex_error;


conn bcom/1234@ndb;
-- 시노님 생성
create or replace synonym sys_init_api  for bsys.sys_init_api;
create or replace synonym sys_valid_api for bsys.sys_valid_api;
create or replace synonym sys_get_api   for bsys.sys_get_api;
create or replace synonym sys_env_f     for bsys.sys_env_f;
create or replace synonym sys_env_api   for bsys.sys_env_api;
create or replace synonym sys_log_api   for bsys.sys_log_api;
create or replace synonym apex_error    for apex_230200.apex_error;
create or replace synonym sys_error_api for bsys.sys_error_api;


-- ------------------------------------------------------------------------------------------------
conn bhrm/1234@ndb;
-- 시노님 생성
create or replace synonym sys_init_api  for bsys.sys_init_api;
create or replace synonym sys_valid_api for bsys.sys_valid_api;
create or replace synonym sys_get_api   for bsys.sys_get_api;
create or replace synonym sys_env_f     for bsys.sys_env_f;
create or replace synonym sys_env_api   for bsys.sys_env_api;
create or replace synonym sys_log_api   for bsys.sys_log_api;
create or replace synonym apex_error    for apex_230200.apex_error;
create or replace synonym sys_error_api for bsys.sys_error_api;


-- ------------------------------------------------------------------------------------------------
conn system/built123$@ndb;
-- 역할 생성
grant execute, debug on bsys.sys_init_api  to bcom with grant option;
grant execute, debug on bsys.sys_init_api  to bhrm with grant option;

grant execute, debug on bsys.sys_valid_api to bcom with grant option;
grant execute, debug on bsys.sys_valid_api to bhrm with grant option;

grant execute, debug on bsys.sys_env_api   to bcom with grant option;
grant execute, debug on bsys.sys_env_api   to bhrm with grant option;

grant execute, debug on bsys.sys_env_f     to bcom with grant option;
grant execute, debug on bsys.sys_env_f     to bhrm with grant option;

grant execute, debug on bsys.sys_get_api   to bcom with grant option;
grant execute, debug on bsys.sys_get_api   to bhrm with grant option;

grant execute, debug on bsys.sys_log_api   to bcom with grant option;
grant execute, debug on bsys.sys_log_api   to bhrm with grant option;

grant execute, debug on bsys.sys_error_api to bcom with grant option;
grant execute, debug on bsys.sys_error_api to bhrm with grant option;


-- ------------------------------------------------------------------------------------------------
conn system/built123$@ndb;
alter user APEX_230200 identified by "1234" account unlock;

conn apex_230200/1234@ndb;
-- 시노님 생성
create or replace synonym sys_error_api    for bsys.sys_error_api;

-- ------------------------------------------------------------------------------------------------
conn system/built123$@ndb;
-- 역할 생성
grant execute, debug on bsys.sys_error_api   to apex_230200 with grant option;