oracle创建只读用户账号

–创建用户
create user hapreader identified by hapreader default tablespace hap_data;
–赋予连接权限
grant connect to hapreader;
–给表权限
SELECT ‘GRANT SELECT ON hap.’ || T.TABLE_NAME || ’ TO hapreader;’
FROM user_tables t
–给只读账户赋创建同义词权限
grant create synonym to hapreader;
–创建同义词语句，切换只读账户执行
SELECT ‘create or replace SYNONYM hapreader.’ || T.TABLE_NAME ||
’ FOR hap.’ || T.TABLE_NAME || ‘;’
from user_tables t