user1是DBA的话可以直接访问其他用户的对象,
例如select * from system.view1
如果user1不是dba,可以用如下方式访问:
1. system:grant select,[Privileges] on view1 to user1;
user1: select * from system.view1;
2. system:create public synonym view1 for system.view1;//公有同义词
grant select,[Privileges] on view1 to user1;
user1:select * from view1;
另外,也可以通过角色授权