Oracle 권한부여

1. Packagae

- grant execute on DB1.P_PACKAGAE_NAME_001C to DB2

 

2. Table or View

- grant DELETE, INSERT, SELECT, UPDATE on DB1.T_TABLENAME to DB2

- create or replace public synonym T_TABLENAME for DB1.T_TABLENAME

 

2.  Sequenc

- grant select, alter on T_TABLENAME_SEQ to DB2

- create public synonym T_TABLENAME_SEQ for DB1.T_TABLENAME_SEQ