ORA-01925:maximum of 80 enabled roles exceeded
来源:互联网 发布:ps软件cs5官方下载 编辑:程序博客网 时间:2024/06/11 07:34
ORA-01925:maximum of 80 enabled roles exceeded
max_enabled_roles 9i的参数,10g及以后都不用了。
指定用户session的最大enabled roles数。
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.
For example, if MAX_ENABLED_ROLES is set to 5, then user HR can have seven roles enabled (the five enabled by MAX_ENABLED_ROLES, plus PUBLIC and HR).
查查系统用得比较多role的用户,但这样查出来,还不包括以role授予给role再授予用户的嵌套情况
select grantee,count(*) from dba_role_privs group by grantee order by count(*) desc;
也可以直接查当前会话enable的role数量
select count(*) from session_roles;
如果用户登陆不上了,必然是授予太多role了。
可以改大参数,但要重启库。
alter system set max_enabled_roles=148 scope=spfile;
嗯,最大值是148,不能设置为更大的了
0 0
- ORA-01925:maximum of 80 enabled roles exceeded
- ORA-01925: maximum of 30 enabled roles exceeded 解决办法!
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00018:maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ora-00059 maximum number of DB_FILES exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- ORA-00020: maximum number of processes (%s) exceeded
- ORA-00018: maximum number of sessions exceeded 解决方法
- ORA-00020: maximum number of processes (500) exceeded
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- ORA-00020: maximum number of processes (%s) exceeded问题解决过程
- ORA-00018:maximum number of sessions exceeded解决方法
- HDU-1247 Hat’s Words (STL:map)
- java 多线程开发三
- C++ 标准头文件与C头文件区别与联系以及C风格字符串
- 探索IOS App的生命周期之启动篇
- iOS越狱(jailbreak)相关
- ORA-01925:maximum of 80 enabled roles exceeded
- 我的java学习日记(16)
- 一定要参加哦!关于大学生思想困惑的调查
- Linux查看当前内存工作频率
- ActionBar
- Linux设备驱动开发
- 设计模式(三)6大原则
- 《C++ Primer》作者Stanley B.Lippman谈C++语言和软件产业的发展
- Linux5.5Vmware安装ORACLE 11G RAC时SSH对等性建立的问题