Oracle监控账号创建【Prometheus】
创建监控账号,禁止赋予dba权限。
create user 监控账号 identified by "监控密码";
grant OEM_MONITOR to 监控账号;
create profile 监控账号_profile limit PASSWORD_LIFE_TIME unlimited;
alter user 监控账号 profile 监控账号_profile;
查看监控账号权限
1、select username,account_status,profile from dba_users where username = '监控账号';
期望输出:
USERNAME ACCOUNT_STATUS PROFILE
---------- -------------------------------- --------------------
BMC OPEN BMC_PROFILE
2、select PROFILE,RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where PROFILE = 'BMC_PROFILE' and RESOURCE_NAME ='PASSWORD_LIFE_TIME';
期望输出:
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------------------- -------- --------------------
B