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

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

语句如下:

SQL> conn /as sysdba;
Connected.
SQL> grant create any synonym to java01;

Grant succeeded.

SQL> conn java01/oracle;
Connected.
SQL> create synonym java02.course for course_table;

Synonym created.

SQL> select * from course;
select * from course
              *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> conn java02/oracle;
Connected.
SQL> select * from course;
select * from course
              *
ERROR at line 1:
ORA-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;

问题解决.

呵呵

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226801/viewspace-200294/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226801/viewspace-200294/