28 个解决方案
#1
你把登陆身份选成sysdba了吧?
应该用normal登,sysdba一般只限sys帐号等录用。
应该用normal登,sysdba一般只限sys帐号等录用。
#2
没有,我就是用的normal登陆的
#3
登陆成功了吗?
是不是在存储过程中报错呢?
如果时要注意角色所俱权限是没有办法赋给存储过程的。
存储过程只能使用用户被赋予的“权限”而不能继承用户角色里的权限。
如果不是这个,而是连登陆都不可以,那就另当别论了。
是不是在存储过程中报错呢?
如果时要注意角色所俱权限是没有办法赋给存储过程的。
存储过程只能使用用户被赋予的“权限”而不能继承用户角色里的权限。
如果不是这个,而是连登陆都不可以,那就另当别论了。
#4
没有登陆成功,这和存储过程没什么关系吧?我现在登陆的是oracle10g的企业管理器,pl/sql或者sqlnaviator用这个用户是可以链接的
#5
是不是你的本地安全设置的 "作为批处理作业登录"里没有添加本机的用户啊!
#6
我用sys用户登陆企业管理器然后给一个普通用户赋予了dba权限
在用这个普通用户登陆方式是normal的,没有问题,只是这样第一次登陆时会让你同意一个协议,
下一次登陆后就没有了。但是我的普通用户除了dba还具有connect和resource权限不知道和这个有没有关系
在用这个普通用户登陆方式是normal的,没有问题,只是这样第一次登陆时会让你同意一个协议,
下一次登陆后就没有了。但是我的普通用户除了dba还具有connect和resource权限不知道和这个有没有关系
#7
dba角色,不能登陆企业管理器?
我开始关注了,请楼主说细致一些。
比如说角色是否进赋予了DBA等等。
另外把这个的检索结果贴一贴
select * from dba_sys_privs
where grantee='DBA'
我开始关注了,请楼主说细致一些。
比如说角色是否进赋予了DBA等等。
另外把这个的检索结果贴一贴
select * from dba_sys_privs
where grantee='DBA'
#8
这是结果
GRANTEE PRIVILEGE ADMIN_OPTION
DBA CREATE ANY SQL PROFILE YES
DBA DROP ANY SQL PROFILE YES
DBA DROP ANY EVALUATION CONTEXT YES
DBA ALTER ANY OUTLINE YES
DBA EXECUTE ANY INDEXTYPE YES
DBA UNDER ANY VIEW YES
DBA DROP ANY LIBRARY YES
DBA ALTER ANY LIBRARY YES
DBA CREATE LIBRARY YES
DBA UNDER ANY TYPE YES
DBA CREATE ANY DIRECTORY YES
DBA DROP PUBLIC SYNONYM YES
DBA DELETE ANY TABLE YES
DBA CREATE TABLE YES
DBA ADMINISTER ANY SQL TUNING SET YES
DBA CREATE ANY EVALUATION CONTEXT YES
DBA GRANT ANY OBJECT PRIVILEGE YES
DBA ADMINISTER RESOURCE MANAGER YES
DBA DEQUEUE ANY QUEUE YES
DBA ENQUEUE ANY QUEUE YES
DBA CREATE ANY DIMENSION YES
DBA CREATE TYPE YES
DBA DROP ANY MATERIALIZED VIEW YES
DBA DROP ANY TRIGGER YES
DBA ALTER ANY PROCEDURE YES
DBA ALTER DATABASE YES
DBA DROP ANY ROLE YES
DBA CREATE SEQUENCE YES
DBA CREATE VIEW YES
DBA ALTER ANY CLUSTER YES
DBA CREATE ANY CLUSTER YES
DBA UPDATE ANY TABLE YES
DBA DROP TABLESPACE YES
DBA ADMINISTER SQL TUNING SET YES
DBA CREATE ANY RULE YES
DBA EXPORT FULL DATABASE YES
DBA CREATE EVALUATION CONTEXT YES
DBA RESUMABLE YES
DBA MERGE ANY VIEW YES
DBA ADMINISTER DATABASE TRIGGER YES
DBA CREATE ANY CONTEXT YES
DBA GLOBAL QUERY REWRITE YES
DBA CREATE INDEXTYPE YES
DBA DROP ANY OPERATOR YES
DBA CREATE ANY LIBRARY YES
DBA DROP ANY TYPE YES
DBA CREATE ANY MATERIALIZED VIEW YES
DBA CREATE PROFILE YES
DBA CREATE ANY PROCEDURE YES
DBA AUDIT ANY YES
DBA CREATE ROLE YES
DBA DROP PUBLIC DATABASE LINK YES
DBA DROP ANY SEQUENCE YES
DBA ALTER ANY SEQUENCE YES
DBA CREATE PUBLIC SYNONYM YES
DBA CREATE ANY SYNONYM YES
DBA DROP ANY INDEX YES
DBA COMMENT ANY TABLE YES
DBA DROP ANY TABLE YES
DBA CREATE ROLLBACK SEGMENT YES
DBA ALTER USER YES
DBA CHANGE NOTIFICATION YES
DBA CREATE ANY JOB YES
DBA ADVISOR YES
DBA ALTER ANY RULE SET YES
DBA ALTER ANY EVALUATION CONTEXT YES
DBA DROP ANY CONTEXT YES
DBA QUERY REWRITE YES
DBA CREATE ANY OPERATOR YES
DBA ALTER RESOURCE COST YES
DBA CREATE TRIGGER YES
DBA DROP ANY PROCEDURE YES
DBA FORCE ANY TRANSACTION YES
DBA CREATE PUBLIC DATABASE LINK YES
DBA SELECT ANY SEQUENCE YES
DBA CREATE SYNONYM YES
DBA BACKUP ANY TABLE YES
DBA ALTER ROLLBACK SEGMENT YES
DBA DROP USER YES
DBA CREATE EXTERNAL JOB YES
DBA ALTER ANY SQL PROFILE YES
DBA DROP ANY DIMENSION YES
DBA CREATE OPERATOR YES
DBA GRANT ANY PRIVILEGE YES
DBA ALTER PROFILE YES
DBA CREATE ANY SEQUENCE YES
DBA DROP ANY VIEW YES
DBA BECOME USER YES
DBA MANAGE FILE GROUP YES
DBA EXECUTE ANY RULE YES
DBA DROP ANY RULE YES
DBA CREATE RULE YES
DBA DEBUG CONNECT SESSION YES
DBA SELECT ANY DICTIONARY NO
DBA ON COMMIT REFRESH YES
DBA DROP ANY OUTLINE YES
DBA CREATE ANY OUTLINE YES
DBA MANAGE ANY QUEUE YES
DBA UNDER ANY TABLE YES
DBA CREATE ANY INDEXTYPE YES
DBA EXECUTE ANY LIBRARY YES
DBA DROP ANY DIRECTORY YES
DBA ALTER ANY MATERIALIZED VIEW YES
DBA ANALYZE ANY YES
DBA EXECUTE ANY PROCEDURE YES
DBA ALTER ANY ROLE YES
DBA DROP ANY CLUSTER YES
DBA SELECT ANY TABLE YES
DBA LOCK ANY TABLE YES
DBA ALTER ANY TABLE YES
DBA CREATE ANY TABLE YES
DBA CREATE USER YES
DBA ALTER TABLESPACE YES
DBA CREATE SESSION YES
DBA READ ANY FILE GROUP YES
DBA SELECT ANY TRANSACTION YES
DBA CREATE JOB YES
DBA IMPORT FULL DATABASE YES
DBA EXECUTE ANY RULE SET YES
DBA DROP ANY RULE SET YES
DBA CREATE RULE SET YES
DBA EXECUTE ANY EVALUATION CONTEXT YES
DBA FLASHBACK ANY TABLE YES
DBA ALTER ANY DIMENSION YES
DBA CREATE DIMENSION YES
DBA ALTER ANY INDEXTYPE YES
DBA EXECUTE ANY OPERATOR YES
DBA EXECUTE ANY TYPE YES
DBA CREATE ANY TRIGGER YES
DBA CREATE PROCEDURE YES
DBA FORCE TRANSACTION YES
DBA CREATE ANY VIEW YES
DBA ALTER ANY INDEX YES
DBA CREATE ANY INDEX YES
DBA INSERT ANY TABLE YES
DBA DROP ROLLBACK SEGMENT YES
DBA ALTER SESSION YES
DBA MANAGE ANY FILE GROUP YES
DBA MANAGE SCHEDULER YES
DBA EXECUTE ANY CLASS YES
DBA EXECUTE ANY PROGRAM YES
DBA ALTER ANY RULE YES
DBA CREATE ANY RULE SET YES
DBA DEBUG ANY PROCEDURE YES
DBA DROP ANY INDEXTYPE YES
DBA ALTER ANY TYPE YES
DBA CREATE ANY TYPE YES
DBA CREATE MATERIALIZED VIEW YES
DBA DROP PROFILE YES
DBA ALTER ANY TRIGGER YES
DBA GRANT ANY ROLE YES
DBA CREATE DATABASE LINK YES
DBA DROP ANY SYNONYM YES
DBA CREATE CLUSTER YES
DBA MANAGE TABLESPACE YES
DBA CREATE TABLESPACE YES
DBA RESTRICTED SESSION YES
DBA AUDIT SYSTEM YES
DBA ALTER SYSTEM YES
GRANTEE PRIVILEGE ADMIN_OPTION
DBA CREATE ANY SQL PROFILE YES
DBA DROP ANY SQL PROFILE YES
DBA DROP ANY EVALUATION CONTEXT YES
DBA ALTER ANY OUTLINE YES
DBA EXECUTE ANY INDEXTYPE YES
DBA UNDER ANY VIEW YES
DBA DROP ANY LIBRARY YES
DBA ALTER ANY LIBRARY YES
DBA CREATE LIBRARY YES
DBA UNDER ANY TYPE YES
DBA CREATE ANY DIRECTORY YES
DBA DROP PUBLIC SYNONYM YES
DBA DELETE ANY TABLE YES
DBA CREATE TABLE YES
DBA ADMINISTER ANY SQL TUNING SET YES
DBA CREATE ANY EVALUATION CONTEXT YES
DBA GRANT ANY OBJECT PRIVILEGE YES
DBA ADMINISTER RESOURCE MANAGER YES
DBA DEQUEUE ANY QUEUE YES
DBA ENQUEUE ANY QUEUE YES
DBA CREATE ANY DIMENSION YES
DBA CREATE TYPE YES
DBA DROP ANY MATERIALIZED VIEW YES
DBA DROP ANY TRIGGER YES
DBA ALTER ANY PROCEDURE YES
DBA ALTER DATABASE YES
DBA DROP ANY ROLE YES
DBA CREATE SEQUENCE YES
DBA CREATE VIEW YES
DBA ALTER ANY CLUSTER YES
DBA CREATE ANY CLUSTER YES
DBA UPDATE ANY TABLE YES
DBA DROP TABLESPACE YES
DBA ADMINISTER SQL TUNING SET YES
DBA CREATE ANY RULE YES
DBA EXPORT FULL DATABASE YES
DBA CREATE EVALUATION CONTEXT YES
DBA RESUMABLE YES
DBA MERGE ANY VIEW YES
DBA ADMINISTER DATABASE TRIGGER YES
DBA CREATE ANY CONTEXT YES
DBA GLOBAL QUERY REWRITE YES
DBA CREATE INDEXTYPE YES
DBA DROP ANY OPERATOR YES
DBA CREATE ANY LIBRARY YES
DBA DROP ANY TYPE YES
DBA CREATE ANY MATERIALIZED VIEW YES
DBA CREATE PROFILE YES
DBA CREATE ANY PROCEDURE YES
DBA AUDIT ANY YES
DBA CREATE ROLE YES
DBA DROP PUBLIC DATABASE LINK YES
DBA DROP ANY SEQUENCE YES
DBA ALTER ANY SEQUENCE YES
DBA CREATE PUBLIC SYNONYM YES
DBA CREATE ANY SYNONYM YES
DBA DROP ANY INDEX YES
DBA COMMENT ANY TABLE YES
DBA DROP ANY TABLE YES
DBA CREATE ROLLBACK SEGMENT YES
DBA ALTER USER YES
DBA CHANGE NOTIFICATION YES
DBA CREATE ANY JOB YES
DBA ADVISOR YES
DBA ALTER ANY RULE SET YES
DBA ALTER ANY EVALUATION CONTEXT YES
DBA DROP ANY CONTEXT YES
DBA QUERY REWRITE YES
DBA CREATE ANY OPERATOR YES
DBA ALTER RESOURCE COST YES
DBA CREATE TRIGGER YES
DBA DROP ANY PROCEDURE YES
DBA FORCE ANY TRANSACTION YES
DBA CREATE PUBLIC DATABASE LINK YES
DBA SELECT ANY SEQUENCE YES
DBA CREATE SYNONYM YES
DBA BACKUP ANY TABLE YES
DBA ALTER ROLLBACK SEGMENT YES
DBA DROP USER YES
DBA CREATE EXTERNAL JOB YES
DBA ALTER ANY SQL PROFILE YES
DBA DROP ANY DIMENSION YES
DBA CREATE OPERATOR YES
DBA GRANT ANY PRIVILEGE YES
DBA ALTER PROFILE YES
DBA CREATE ANY SEQUENCE YES
DBA DROP ANY VIEW YES
DBA BECOME USER YES
DBA MANAGE FILE GROUP YES
DBA EXECUTE ANY RULE YES
DBA DROP ANY RULE YES
DBA CREATE RULE YES
DBA DEBUG CONNECT SESSION YES
DBA SELECT ANY DICTIONARY NO
DBA ON COMMIT REFRESH YES
DBA DROP ANY OUTLINE YES
DBA CREATE ANY OUTLINE YES
DBA MANAGE ANY QUEUE YES
DBA UNDER ANY TABLE YES
DBA CREATE ANY INDEXTYPE YES
DBA EXECUTE ANY LIBRARY YES
DBA DROP ANY DIRECTORY YES
DBA ALTER ANY MATERIALIZED VIEW YES
DBA ANALYZE ANY YES
DBA EXECUTE ANY PROCEDURE YES
DBA ALTER ANY ROLE YES
DBA DROP ANY CLUSTER YES
DBA SELECT ANY TABLE YES
DBA LOCK ANY TABLE YES
DBA ALTER ANY TABLE YES
DBA CREATE ANY TABLE YES
DBA CREATE USER YES
DBA ALTER TABLESPACE YES
DBA CREATE SESSION YES
DBA READ ANY FILE GROUP YES
DBA SELECT ANY TRANSACTION YES
DBA CREATE JOB YES
DBA IMPORT FULL DATABASE YES
DBA EXECUTE ANY RULE SET YES
DBA DROP ANY RULE SET YES
DBA CREATE RULE SET YES
DBA EXECUTE ANY EVALUATION CONTEXT YES
DBA FLASHBACK ANY TABLE YES
DBA ALTER ANY DIMENSION YES
DBA CREATE DIMENSION YES
DBA ALTER ANY INDEXTYPE YES
DBA EXECUTE ANY OPERATOR YES
DBA EXECUTE ANY TYPE YES
DBA CREATE ANY TRIGGER YES
DBA CREATE PROCEDURE YES
DBA FORCE TRANSACTION YES
DBA CREATE ANY VIEW YES
DBA ALTER ANY INDEX YES
DBA CREATE ANY INDEX YES
DBA INSERT ANY TABLE YES
DBA DROP ROLLBACK SEGMENT YES
DBA ALTER SESSION YES
DBA MANAGE ANY FILE GROUP YES
DBA MANAGE SCHEDULER YES
DBA EXECUTE ANY CLASS YES
DBA EXECUTE ANY PROGRAM YES
DBA ALTER ANY RULE YES
DBA CREATE ANY RULE SET YES
DBA DEBUG ANY PROCEDURE YES
DBA DROP ANY INDEXTYPE YES
DBA ALTER ANY TYPE YES
DBA CREATE ANY TYPE YES
DBA CREATE MATERIALIZED VIEW YES
DBA DROP PROFILE YES
DBA ALTER ANY TRIGGER YES
DBA GRANT ANY ROLE YES
DBA CREATE DATABASE LINK YES
DBA DROP ANY SYNONYM YES
DBA CREATE CLUSTER YES
DBA MANAGE TABLESPACE YES
DBA CREATE TABLESPACE YES
DBA RESTRICTED SESSION YES
DBA AUDIT SYSTEM YES
DBA ALTER SYSTEM YES
#9
我是通过http://ip地址:1158/em 登陆oracle10g的
#10
没人能解决吗
#11
sys帐号和system帐号如果也不能登陆,说明是EM配置的问题,
否则的话很可能是你的登录用户权限分配不成功。
eM在登录的时候需要判断你的权限是否具备EM启动所需的那么多,所以有时sqlplus可以连接的用户不能连接em。
否则的话很可能是你的登录用户权限分配不成功。
eM在登录的时候需要判断你的权限是否具备EM启动所需的那么多,所以有时sqlplus可以连接的用户不能连接em。
#12
ding!!!!!!!!!!!!!!
#13
EM启动所需权限都有哪些
#14
我也遇到了,权限太大了,oracle正常设置读不出来,提示要特别版。
错误
应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。
错误
应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。
#15
以上问题把权限恢复了应该是可以解决了,但进不了权限设置..............
#16
这个问题很好解决:你只要赋予这个用户SELECT_CATALOG_ROLE这个角色即可。
SELECT_CATALOG_ROLE is provided for accessing data dictionary views and packages 。
SELECT_CATALOG_ROLE is provided for accessing data dictionary views and packages 。
#17
正解,谢谢!
#18
你只要赋予这个用户SELECT_CATALOG_ROLE这个角色即可。 正解
#19
sorry ,i too
#20
哈哈
我用 grant SELECT_CATALOG_ROLE to peter; 解决了该问题
我用 grant SELECT_CATALOG_ROLE to peter; 解决了该问题
#21
哎,我遇到这个问题了,搜了半天的资料,无果,自己试试,原来是sys,DBSNMP,SYSMAN这三个用户的密码被改过,需要重新配置一下em:$emca -config dbcontrol db
然后就可以了
然后就可以了
#22
han
#23
grant SELECT_CATALOG_ROLE to peter; 正解!感谢。。
#24
正解
#25
以DBA的身份登录,只能是sys用户和sysoper用户
以normal身份登录,需要grant SELECT_CATALOG_ROLE to peter授权某个账户即可
以normal身份登录,需要grant SELECT_CATALOG_ROLE to peter授权某个账户即可
#26
grant SELECT_CATALOG_ROLE to user
#27
突然发现这个是 08年的帖子
#28
我是用scott登录时提示楼主提示的问题,用这个方法解决了。谢谢。
#1
你把登陆身份选成sysdba了吧?
应该用normal登,sysdba一般只限sys帐号等录用。
应该用normal登,sysdba一般只限sys帐号等录用。
#2
没有,我就是用的normal登陆的
#3
登陆成功了吗?
是不是在存储过程中报错呢?
如果时要注意角色所俱权限是没有办法赋给存储过程的。
存储过程只能使用用户被赋予的“权限”而不能继承用户角色里的权限。
如果不是这个,而是连登陆都不可以,那就另当别论了。
是不是在存储过程中报错呢?
如果时要注意角色所俱权限是没有办法赋给存储过程的。
存储过程只能使用用户被赋予的“权限”而不能继承用户角色里的权限。
如果不是这个,而是连登陆都不可以,那就另当别论了。
#4
没有登陆成功,这和存储过程没什么关系吧?我现在登陆的是oracle10g的企业管理器,pl/sql或者sqlnaviator用这个用户是可以链接的
#5
是不是你的本地安全设置的 "作为批处理作业登录"里没有添加本机的用户啊!
#6
我用sys用户登陆企业管理器然后给一个普通用户赋予了dba权限
在用这个普通用户登陆方式是normal的,没有问题,只是这样第一次登陆时会让你同意一个协议,
下一次登陆后就没有了。但是我的普通用户除了dba还具有connect和resource权限不知道和这个有没有关系
在用这个普通用户登陆方式是normal的,没有问题,只是这样第一次登陆时会让你同意一个协议,
下一次登陆后就没有了。但是我的普通用户除了dba还具有connect和resource权限不知道和这个有没有关系
#7
dba角色,不能登陆企业管理器?
我开始关注了,请楼主说细致一些。
比如说角色是否进赋予了DBA等等。
另外把这个的检索结果贴一贴
select * from dba_sys_privs
where grantee='DBA'
我开始关注了,请楼主说细致一些。
比如说角色是否进赋予了DBA等等。
另外把这个的检索结果贴一贴
select * from dba_sys_privs
where grantee='DBA'
#8
这是结果
GRANTEE PRIVILEGE ADMIN_OPTION
DBA CREATE ANY SQL PROFILE YES
DBA DROP ANY SQL PROFILE YES
DBA DROP ANY EVALUATION CONTEXT YES
DBA ALTER ANY OUTLINE YES
DBA EXECUTE ANY INDEXTYPE YES
DBA UNDER ANY VIEW YES
DBA DROP ANY LIBRARY YES
DBA ALTER ANY LIBRARY YES
DBA CREATE LIBRARY YES
DBA UNDER ANY TYPE YES
DBA CREATE ANY DIRECTORY YES
DBA DROP PUBLIC SYNONYM YES
DBA DELETE ANY TABLE YES
DBA CREATE TABLE YES
DBA ADMINISTER ANY SQL TUNING SET YES
DBA CREATE ANY EVALUATION CONTEXT YES
DBA GRANT ANY OBJECT PRIVILEGE YES
DBA ADMINISTER RESOURCE MANAGER YES
DBA DEQUEUE ANY QUEUE YES
DBA ENQUEUE ANY QUEUE YES
DBA CREATE ANY DIMENSION YES
DBA CREATE TYPE YES
DBA DROP ANY MATERIALIZED VIEW YES
DBA DROP ANY TRIGGER YES
DBA ALTER ANY PROCEDURE YES
DBA ALTER DATABASE YES
DBA DROP ANY ROLE YES
DBA CREATE SEQUENCE YES
DBA CREATE VIEW YES
DBA ALTER ANY CLUSTER YES
DBA CREATE ANY CLUSTER YES
DBA UPDATE ANY TABLE YES
DBA DROP TABLESPACE YES
DBA ADMINISTER SQL TUNING SET YES
DBA CREATE ANY RULE YES
DBA EXPORT FULL DATABASE YES
DBA CREATE EVALUATION CONTEXT YES
DBA RESUMABLE YES
DBA MERGE ANY VIEW YES
DBA ADMINISTER DATABASE TRIGGER YES
DBA CREATE ANY CONTEXT YES
DBA GLOBAL QUERY REWRITE YES
DBA CREATE INDEXTYPE YES
DBA DROP ANY OPERATOR YES
DBA CREATE ANY LIBRARY YES
DBA DROP ANY TYPE YES
DBA CREATE ANY MATERIALIZED VIEW YES
DBA CREATE PROFILE YES
DBA CREATE ANY PROCEDURE YES
DBA AUDIT ANY YES
DBA CREATE ROLE YES
DBA DROP PUBLIC DATABASE LINK YES
DBA DROP ANY SEQUENCE YES
DBA ALTER ANY SEQUENCE YES
DBA CREATE PUBLIC SYNONYM YES
DBA CREATE ANY SYNONYM YES
DBA DROP ANY INDEX YES
DBA COMMENT ANY TABLE YES
DBA DROP ANY TABLE YES
DBA CREATE ROLLBACK SEGMENT YES
DBA ALTER USER YES
DBA CHANGE NOTIFICATION YES
DBA CREATE ANY JOB YES
DBA ADVISOR YES
DBA ALTER ANY RULE SET YES
DBA ALTER ANY EVALUATION CONTEXT YES
DBA DROP ANY CONTEXT YES
DBA QUERY REWRITE YES
DBA CREATE ANY OPERATOR YES
DBA ALTER RESOURCE COST YES
DBA CREATE TRIGGER YES
DBA DROP ANY PROCEDURE YES
DBA FORCE ANY TRANSACTION YES
DBA CREATE PUBLIC DATABASE LINK YES
DBA SELECT ANY SEQUENCE YES
DBA CREATE SYNONYM YES
DBA BACKUP ANY TABLE YES
DBA ALTER ROLLBACK SEGMENT YES
DBA DROP USER YES
DBA CREATE EXTERNAL JOB YES
DBA ALTER ANY SQL PROFILE YES
DBA DROP ANY DIMENSION YES
DBA CREATE OPERATOR YES
DBA GRANT ANY PRIVILEGE YES
DBA ALTER PROFILE YES
DBA CREATE ANY SEQUENCE YES
DBA DROP ANY VIEW YES
DBA BECOME USER YES
DBA MANAGE FILE GROUP YES
DBA EXECUTE ANY RULE YES
DBA DROP ANY RULE YES
DBA CREATE RULE YES
DBA DEBUG CONNECT SESSION YES
DBA SELECT ANY DICTIONARY NO
DBA ON COMMIT REFRESH YES
DBA DROP ANY OUTLINE YES
DBA CREATE ANY OUTLINE YES
DBA MANAGE ANY QUEUE YES
DBA UNDER ANY TABLE YES
DBA CREATE ANY INDEXTYPE YES
DBA EXECUTE ANY LIBRARY YES
DBA DROP ANY DIRECTORY YES
DBA ALTER ANY MATERIALIZED VIEW YES
DBA ANALYZE ANY YES
DBA EXECUTE ANY PROCEDURE YES
DBA ALTER ANY ROLE YES
DBA DROP ANY CLUSTER YES
DBA SELECT ANY TABLE YES
DBA LOCK ANY TABLE YES
DBA ALTER ANY TABLE YES
DBA CREATE ANY TABLE YES
DBA CREATE USER YES
DBA ALTER TABLESPACE YES
DBA CREATE SESSION YES
DBA READ ANY FILE GROUP YES
DBA SELECT ANY TRANSACTION YES
DBA CREATE JOB YES
DBA IMPORT FULL DATABASE YES
DBA EXECUTE ANY RULE SET YES
DBA DROP ANY RULE SET YES
DBA CREATE RULE SET YES
DBA EXECUTE ANY EVALUATION CONTEXT YES
DBA FLASHBACK ANY TABLE YES
DBA ALTER ANY DIMENSION YES
DBA CREATE DIMENSION YES
DBA ALTER ANY INDEXTYPE YES
DBA EXECUTE ANY OPERATOR YES
DBA EXECUTE ANY TYPE YES
DBA CREATE ANY TRIGGER YES
DBA CREATE PROCEDURE YES
DBA FORCE TRANSACTION YES
DBA CREATE ANY VIEW YES
DBA ALTER ANY INDEX YES
DBA CREATE ANY INDEX YES
DBA INSERT ANY TABLE YES
DBA DROP ROLLBACK SEGMENT YES
DBA ALTER SESSION YES
DBA MANAGE ANY FILE GROUP YES
DBA MANAGE SCHEDULER YES
DBA EXECUTE ANY CLASS YES
DBA EXECUTE ANY PROGRAM YES
DBA ALTER ANY RULE YES
DBA CREATE ANY RULE SET YES
DBA DEBUG ANY PROCEDURE YES
DBA DROP ANY INDEXTYPE YES
DBA ALTER ANY TYPE YES
DBA CREATE ANY TYPE YES
DBA CREATE MATERIALIZED VIEW YES
DBA DROP PROFILE YES
DBA ALTER ANY TRIGGER YES
DBA GRANT ANY ROLE YES
DBA CREATE DATABASE LINK YES
DBA DROP ANY SYNONYM YES
DBA CREATE CLUSTER YES
DBA MANAGE TABLESPACE YES
DBA CREATE TABLESPACE YES
DBA RESTRICTED SESSION YES
DBA AUDIT SYSTEM YES
DBA ALTER SYSTEM YES
GRANTEE PRIVILEGE ADMIN_OPTION
DBA CREATE ANY SQL PROFILE YES
DBA DROP ANY SQL PROFILE YES
DBA DROP ANY EVALUATION CONTEXT YES
DBA ALTER ANY OUTLINE YES
DBA EXECUTE ANY INDEXTYPE YES
DBA UNDER ANY VIEW YES
DBA DROP ANY LIBRARY YES
DBA ALTER ANY LIBRARY YES
DBA CREATE LIBRARY YES
DBA UNDER ANY TYPE YES
DBA CREATE ANY DIRECTORY YES
DBA DROP PUBLIC SYNONYM YES
DBA DELETE ANY TABLE YES
DBA CREATE TABLE YES
DBA ADMINISTER ANY SQL TUNING SET YES
DBA CREATE ANY EVALUATION CONTEXT YES
DBA GRANT ANY OBJECT PRIVILEGE YES
DBA ADMINISTER RESOURCE MANAGER YES
DBA DEQUEUE ANY QUEUE YES
DBA ENQUEUE ANY QUEUE YES
DBA CREATE ANY DIMENSION YES
DBA CREATE TYPE YES
DBA DROP ANY MATERIALIZED VIEW YES
DBA DROP ANY TRIGGER YES
DBA ALTER ANY PROCEDURE YES
DBA ALTER DATABASE YES
DBA DROP ANY ROLE YES
DBA CREATE SEQUENCE YES
DBA CREATE VIEW YES
DBA ALTER ANY CLUSTER YES
DBA CREATE ANY CLUSTER YES
DBA UPDATE ANY TABLE YES
DBA DROP TABLESPACE YES
DBA ADMINISTER SQL TUNING SET YES
DBA CREATE ANY RULE YES
DBA EXPORT FULL DATABASE YES
DBA CREATE EVALUATION CONTEXT YES
DBA RESUMABLE YES
DBA MERGE ANY VIEW YES
DBA ADMINISTER DATABASE TRIGGER YES
DBA CREATE ANY CONTEXT YES
DBA GLOBAL QUERY REWRITE YES
DBA CREATE INDEXTYPE YES
DBA DROP ANY OPERATOR YES
DBA CREATE ANY LIBRARY YES
DBA DROP ANY TYPE YES
DBA CREATE ANY MATERIALIZED VIEW YES
DBA CREATE PROFILE YES
DBA CREATE ANY PROCEDURE YES
DBA AUDIT ANY YES
DBA CREATE ROLE YES
DBA DROP PUBLIC DATABASE LINK YES
DBA DROP ANY SEQUENCE YES
DBA ALTER ANY SEQUENCE YES
DBA CREATE PUBLIC SYNONYM YES
DBA CREATE ANY SYNONYM YES
DBA DROP ANY INDEX YES
DBA COMMENT ANY TABLE YES
DBA DROP ANY TABLE YES
DBA CREATE ROLLBACK SEGMENT YES
DBA ALTER USER YES
DBA CHANGE NOTIFICATION YES
DBA CREATE ANY JOB YES
DBA ADVISOR YES
DBA ALTER ANY RULE SET YES
DBA ALTER ANY EVALUATION CONTEXT YES
DBA DROP ANY CONTEXT YES
DBA QUERY REWRITE YES
DBA CREATE ANY OPERATOR YES
DBA ALTER RESOURCE COST YES
DBA CREATE TRIGGER YES
DBA DROP ANY PROCEDURE YES
DBA FORCE ANY TRANSACTION YES
DBA CREATE PUBLIC DATABASE LINK YES
DBA SELECT ANY SEQUENCE YES
DBA CREATE SYNONYM YES
DBA BACKUP ANY TABLE YES
DBA ALTER ROLLBACK SEGMENT YES
DBA DROP USER YES
DBA CREATE EXTERNAL JOB YES
DBA ALTER ANY SQL PROFILE YES
DBA DROP ANY DIMENSION YES
DBA CREATE OPERATOR YES
DBA GRANT ANY PRIVILEGE YES
DBA ALTER PROFILE YES
DBA CREATE ANY SEQUENCE YES
DBA DROP ANY VIEW YES
DBA BECOME USER YES
DBA MANAGE FILE GROUP YES
DBA EXECUTE ANY RULE YES
DBA DROP ANY RULE YES
DBA CREATE RULE YES
DBA DEBUG CONNECT SESSION YES
DBA SELECT ANY DICTIONARY NO
DBA ON COMMIT REFRESH YES
DBA DROP ANY OUTLINE YES
DBA CREATE ANY OUTLINE YES
DBA MANAGE ANY QUEUE YES
DBA UNDER ANY TABLE YES
DBA CREATE ANY INDEXTYPE YES
DBA EXECUTE ANY LIBRARY YES
DBA DROP ANY DIRECTORY YES
DBA ALTER ANY MATERIALIZED VIEW YES
DBA ANALYZE ANY YES
DBA EXECUTE ANY PROCEDURE YES
DBA ALTER ANY ROLE YES
DBA DROP ANY CLUSTER YES
DBA SELECT ANY TABLE YES
DBA LOCK ANY TABLE YES
DBA ALTER ANY TABLE YES
DBA CREATE ANY TABLE YES
DBA CREATE USER YES
DBA ALTER TABLESPACE YES
DBA CREATE SESSION YES
DBA READ ANY FILE GROUP YES
DBA SELECT ANY TRANSACTION YES
DBA CREATE JOB YES
DBA IMPORT FULL DATABASE YES
DBA EXECUTE ANY RULE SET YES
DBA DROP ANY RULE SET YES
DBA CREATE RULE SET YES
DBA EXECUTE ANY EVALUATION CONTEXT YES
DBA FLASHBACK ANY TABLE YES
DBA ALTER ANY DIMENSION YES
DBA CREATE DIMENSION YES
DBA ALTER ANY INDEXTYPE YES
DBA EXECUTE ANY OPERATOR YES
DBA EXECUTE ANY TYPE YES
DBA CREATE ANY TRIGGER YES
DBA CREATE PROCEDURE YES
DBA FORCE TRANSACTION YES
DBA CREATE ANY VIEW YES
DBA ALTER ANY INDEX YES
DBA CREATE ANY INDEX YES
DBA INSERT ANY TABLE YES
DBA DROP ROLLBACK SEGMENT YES
DBA ALTER SESSION YES
DBA MANAGE ANY FILE GROUP YES
DBA MANAGE SCHEDULER YES
DBA EXECUTE ANY CLASS YES
DBA EXECUTE ANY PROGRAM YES
DBA ALTER ANY RULE YES
DBA CREATE ANY RULE SET YES
DBA DEBUG ANY PROCEDURE YES
DBA DROP ANY INDEXTYPE YES
DBA ALTER ANY TYPE YES
DBA CREATE ANY TYPE YES
DBA CREATE MATERIALIZED VIEW YES
DBA DROP PROFILE YES
DBA ALTER ANY TRIGGER YES
DBA GRANT ANY ROLE YES
DBA CREATE DATABASE LINK YES
DBA DROP ANY SYNONYM YES
DBA CREATE CLUSTER YES
DBA MANAGE TABLESPACE YES
DBA CREATE TABLESPACE YES
DBA RESTRICTED SESSION YES
DBA AUDIT SYSTEM YES
DBA ALTER SYSTEM YES
#9
我是通过http://ip地址:1158/em 登陆oracle10g的
#10
没人能解决吗
#11
sys帐号和system帐号如果也不能登陆,说明是EM配置的问题,
否则的话很可能是你的登录用户权限分配不成功。
eM在登录的时候需要判断你的权限是否具备EM启动所需的那么多,所以有时sqlplus可以连接的用户不能连接em。
否则的话很可能是你的登录用户权限分配不成功。
eM在登录的时候需要判断你的权限是否具备EM启动所需的那么多,所以有时sqlplus可以连接的用户不能连接em。
#12
ding!!!!!!!!!!!!!!
#13
EM启动所需权限都有哪些
#14
我也遇到了,权限太大了,oracle正常设置读不出来,提示要特别版。
错误
应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。
错误
应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。
#15
以上问题把权限恢复了应该是可以解决了,但进不了权限设置..............
#16
这个问题很好解决:你只要赋予这个用户SELECT_CATALOG_ROLE这个角色即可。
SELECT_CATALOG_ROLE is provided for accessing data dictionary views and packages 。
SELECT_CATALOG_ROLE is provided for accessing data dictionary views and packages 。
#17
正解,谢谢!
#18
你只要赋予这个用户SELECT_CATALOG_ROLE这个角色即可。 正解
#19
sorry ,i too
#20
哈哈
我用 grant SELECT_CATALOG_ROLE to peter; 解决了该问题
我用 grant SELECT_CATALOG_ROLE to peter; 解决了该问题
#21
哎,我遇到这个问题了,搜了半天的资料,无果,自己试试,原来是sys,DBSNMP,SYSMAN这三个用户的密码被改过,需要重新配置一下em:$emca -config dbcontrol db
然后就可以了
然后就可以了
#22
han
#23
grant SELECT_CATALOG_ROLE to peter; 正解!感谢。。
#24
正解
#25
以DBA的身份登录,只能是sys用户和sysoper用户
以normal身份登录,需要grant SELECT_CATALOG_ROLE to peter授权某个账户即可
以normal身份登录,需要grant SELECT_CATALOG_ROLE to peter授权某个账户即可
#26
grant SELECT_CATALOG_ROLE to user
#27
突然发现这个是 08年的帖子
#28
我是用scott登录时提示楼主提示的问题,用这个方法解决了。谢谢。