创建同意词 CREATE SYNONYM STUFF_M_CUS FOR MATT.STUFF_M_CUS;找出所以需要建同义词的表﹐视图及存储过程 SELECT 'create synonym ' || NAME || ' FOR BS1SG.'||NAME||';' FROM (SELECT DISTINCT TABLE_NAME NAME FROM ALL_TABLES WHERE OWNER='sys')首先你要把那些table的權限授給用戶bb然后再用戶bb下面執行創建同義詞的語法就可以了
conn sys/****@xx; create public synonym T_TEST for sys.T_TEST; grant select on T_TEST to bb; conn bb/**@xx; select * from T_TEST;
SELECT 'create synonym ' || NAME || ' FOR BS1SG.'||NAME||';' FROM (SELECT DISTINCT TABLE_NAME NAME FROM ALL_TABLES WHERE OWNER='sys')這段語法是找出所用sys用戶下面的表生成創建同義詞的語法。然后拷出這些語法去執行﹐不用一個一個的寫
SELECT 'create synonym ' || NAME || ' FOR sys.'||NAME||';' FROM (SELECT DISTINCT TABLE_NAME NAME FROM ALL_TABLES WHERE OWNER='sys')上面的用戶一地方寫錯了應該是sys我沒改過來。以此為准如果要建視圖的改成All_view,存儲過程為﹕All_source格式一樣
每当SYS用户下的T_TEST表变化是,bb用户下的表也相应变化,保持同步.
如此一来,相当于bb下的表就是SYS下的表.
实现了你希望的那样.
CREATE SYNONYM STUFF_M_CUS FOR MATT.STUFF_M_CUS;找出所以需要建同义词的表﹐视图及存储过程
SELECT 'create synonym ' || NAME || ' FOR BS1SG.'||NAME||';'
FROM (SELECT DISTINCT TABLE_NAME NAME
FROM ALL_TABLES
WHERE OWNER='sys')首先你要把那些table的權限授給用戶bb然后再用戶bb下面執行創建同義詞的語法就可以了
create public synonym T_TEST for sys.T_TEST;
grant select on T_TEST to bb;
conn bb/**@xx;
select * from T_TEST;
FROM (SELECT DISTINCT TABLE_NAME NAME
FROM ALL_TABLES
WHERE OWNER='sys')這段語法是找出所用sys用戶下面的表生成創建同義詞的語法。然后拷出這些語法去執行﹐不用一個一個的寫
FROM (SELECT DISTINCT TABLE_NAME NAME
FROM ALL_TABLES
WHERE OWNER='sys')上面的用戶一地方寫錯了應該是sys我沒改過來。以此為准如果要建視圖的改成All_view,存儲過程為﹕All_source格式一樣