新建只读用户

客户新上一台数据库防火墙，需要创建一个全库的只读用户。

操作如下

USR_FW的初始化密码 ORCL#2023

create user USR_FW identified by ORCL#2023;

grant connect to USR_FW;

grant select on DBA_USERS to USR_FW ;

grant select on DBA_SYS_PRIVS to USR_FW ;

grant select on DBA_TAB_PRIVS to USR_FW ;

grant select on DBA_COL_PRIVS to USR_FW ;

grant select on DBA_ROLE_PRIVS to USR_FW ;

grant select on DBA_OBJECTS to USR_FW ;