oracle的权限有个很有意思的现像

朋友建了一个同意词.用户java1把同意词建到java2下面去了.

语句如下:

SQL> conn /as sysdba;ITPUB个人空间 i+[w]B!k-FU
Connected.ITPUB个人空间N9f
q&q H3W7y2W2tQ R)P
SQL> grant create any synonym to java01;

Grant succeeded.

SQL> conn java01/oracle;ITPUB个人空间e6TVQ\lm
Connected.ITPUB个人空间\3a#f^5\ing1~
SQL> create synonym java02.course for course_table;

Synonym created.

SQL> select * from course;

`\0@-n
wm L]Qd"U0select * from courseITPUB个人空间0D4@)@;KtlG
              *
,S!G'f3~R0ERROR at line 1:
8Em!\?hi arTnU!o0ORA-00942: table or view does not exist

ITPUB个人空间(T1_)ai1{
SQL> conn java02/oracle;ITPUB个人空间%L-RPc]R1^-s1^vg2ct
Connected.
OC4o)P{0\^P0SQL> select * from course;
Dx S-Ieo$q |0select * from courseITPUB个人空间:d;\cZ)p
              *
L+o!x,v8N].S8R5S+E0ERROR at line 1:
5n8f5K5SBk/w-V%p#R~J0ORA-00942: table or view does not exist

这样的后果是:java1是创建者.java2是所有者.但两个用户都没有权限访问.挺有意思.

当然,解决这个问题的办法就是相互授权:

1.联接到java1下.执行grant select on java2.course to java2;

2.联接到java2下.执行grant select on course to java1;

问题解决.

呵呵