1:以sysdba登陸系統(tǒng),首先創(chuàng)建一個(gè)用戶
SQL> conn / as sysdba Connected. SQL > create user yshy identified by yshy; User created. SQL > grant connect to yshy; Grant succeeded. SQL > grant resource to yshy; Grant succeeded. SQL > grant create synonym to yshy; Grant succeeded. SQL >
2:切換到y(tǒng)shy用戶,并創(chuàng)建同義詞針對scott.emp
SQL> conn yshy/ yshy Connected. SQL > create synonym y_emp for scott.emp; Synonym created.
3:查詢同義詞,提示表或視圖不存在。
SQL> select * from y_emp; select * from y_emp * ERROR at line 1 : ORA - 00942 : table or view does not exist SQL >
4:登陸scott把emp表的查詢權(quán)限授權(quán)給yshy用戶。
SQL> conn scott/ tiger Connected. SQL > grant select on emp to yshy; Grant succeeded. SQL > conn yshy/ yshy; Connected. SQL > select * from y_emp;
【刪除同義詞】
DROP [PUBLIC] SYNONYM [schema.]sysnonym_name
?
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯(lián)系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長非常感激您!手機(jī)微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
