1.创建一个只读账号
create user MFG_Q identified by Xysd#123456;
alter user mfg_q default tablespace users;
2.连接到需要将对象给只读账号MFG_Q上面，用for循环遍历将所有表得权限给MFG_Q
conn p1rptdw/******
grant select any table to mfg_q;
BEGIN
FOR t IN (SELECT table_name FROM user_tables)
LOOP
EXECUTE IMMEDIATE 'GRANT SELECT ON ' || t.table_name || ' TO mfg_q';
END LOOP;
END;
/
3.连接到MFG_Q只读账号查看p1rptdw的表，验证
select * from p1rptods.SP_ETL_LOG;