以管理员权限登录,创建用户:
create user test identified by testdb;
grant connect to test;
grant select any table to test; --赋予读权限
测试:
select * from olduser.table;
其它:
grant debug any procedure to u1;
grant debug connect session to u1;
grant select any dictionary to u1;
grant select any sequence to u1;