Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles. | ORACLE故障排查 | ORACLE技术论坛

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles.
2015 年 10 月 21 日
15:06
惜分飞
Admin
Forum Posts: 349
Member Since:
2010 年 07 月 31 日
Offline

Tue Oct 20 06:18:52 2015
Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles.
Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles.
Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles.
Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles.

SQL> select "Grantee", count(*) "Role Number" from
2 (
3 select distinct connect_by_root grantee "Grantee", granted_role
4 from dba_role_privs
5 connect by prior granted_role=grantee
6 ) where GRANTEE='ZLHIS'
7 group by "Grantee"
8 order by "Grantee","Role Number"
9 /

GRANTEE COUNT(*)
—————————— ———-
ZLHIS 154

SQL> show parameter max_enabled_roles

NAME TYPE VALUE
———————————— ———-- ————
max_enabled_roles integer 150

SQL> select distinct connect_by_root grantee,granted_role
2 from dba_role_privs
3 connect by prior granted_role=grantee
4 start with grantee='ZLHIS';

CONNECT_BY_ROOTGRANTEE GRANTED_ROLE
—————————— ——————————
ZLHIS XDBADMIN
ZLHIS RESOURCE
…………
ZLHIS ZL_退费对账
ZLHIS ZL_物价科
ZLHIS ZL_物资报表
ZLHIS ZL_银行收入
ZLHIS ZL_中药房

已选择154行。

 

MAX_ENABLED_ROLES specifies the maximum number of database roles that users can enable, including roles contained within other roles. The actual number of roles that users can enable is 2 plus the value of MAX_ENABLED_ROLES, because each user has two additional roles, PUBLIC and the user's own role.

MAX_ENABLED_ROLES表示用户最大可以包含的role数量,这个里面包括了递归role.由于数据库的角色有public和owner两个,因此一个用户最大可以允许的角色数量为MAX_ENABLED_ROLES配置的两倍

 

该参数在10.2/11.2/12.1中已经舍弃,有该参数存在是为了向下兼容,设置了值并不影响使用,但是当不够之时会提示在alert日志中的类似记录"Maximum of 148 enabled roles exceeded for user ZLHIS. Not loading all the roles."

 

如果不想看到相关提示,可以考虑合并role,或者设置部分role为非default

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。