1、首先假设需要建立的用户名:search。密码:mima,

2、然后执行以下命令建立用户:create user search identified by passwd;
3、再执行命令建立连接:grant connect to search ;
4、赋予用户只读表的权限:grant select any table to search;
5、赋予用户只读存储过程的权限:grant execute any procedure to search;