Devlinker -Software Developer

ORACLE 프로시져생성, 권한, Synonym 1. 시노님을 만든다. CREATE SYNONYM USER_ID.PROCEDURE_NAME FOR OWN_ID.PROCEDURE_NAME; (CREATE SYNONYM 줄계정.프로시져명FOR 생성자계정.프로시져명; ) 2. 실행권한을 부여 한다. GRANT EXECUTE on OWN_ID.PROCEDURE_NAME TO USER_ID; (GRANT EXECUTE on 생성자계정.프로시져명TO 줄계정;) CREATE SYNONYM 줄계정.프로시져명FOR 생성자계정.프로시져명;