oracle创建只读用户

以管理员权限登录，创建用户：

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;