schema.object
SYNONYM
ALTER SESSION SET CURRENT_SCHEMA = other_schema
ALTER SESSION
-- 不想建 SYNONYM 又不想寫 schema 前綴 ALTER SESSION SET CURRENT_SCHEMA = other_user; SELECT * FROM their_table; -- 直接訪問 other_user.their_table
會話結束自動還原,不影響其他會話。
EM 左側導航四大類: