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; 另外,也可以通过角色授权
例如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;
另外,也可以通过角色授权
1.grant ... 給權限
2.DBLINK
其次grant select on view1 to user01;
因该就只能看了吧。
不过看得时候得写select * from System.view1