创建监控账号，禁止赋予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