[Oracle] Synonym

Ja L·2023년 7월 7일
0

[Oracle]

목록 보기
1/2
post-thumbnail

-- system/oracle
create user jacreate2 identified by 1234 ;
grant all privileges to jacreate2 ;

-- jacreate2/1234
create table test_syn(id int, name varchar(10));
insert into test_syn values (1,'lee');
select * from test_syn;

CREATE PUBLIC SYNONYM syn2 FOR test_syn;
select * from syn2 ;

GRANT SELECT ON jacreate2.syn2 TO system;

-- system/oracle
SELECT * FROM SYN2 ;

profile
DB Engineer

0개의 댓글