dba角色,不能登陆企业管理器? 我开始关注了,请楼主说细致一些。 比如说角色是否进赋予了DBA等等。 另外把这个的检索结果贴一贴 select * from dba_sys_privs where grantee='DBA'
这是结果 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
应该用normal登,sysdba一般只限sys帐号等录用。
在用这个普通用户登陆方式是normal的,没有问题,只是这样第一次登陆时会让你同意一个协议,
下一次登陆后就没有了。但是我的普通用户除了dba还具有connect和resource权限不知道和这个有没有关系
我开始关注了,请楼主说细致一些。
比如说角色是否进赋予了DBA等等。
另外把这个的检索结果贴一贴
select * from dba_sys_privs
where grantee='DBA'
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
否则的话很可能是你的登录用户权限分配不成功。
eM在登录的时候需要判断你的权限是否具备EM启动所需的那么多,所以有时sqlplus可以连接的用户不能连接em。
错误
应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。
SELECT_CATALOG_ROLE is provided for accessing data dictionary views and packages 。
我用 grant SELECT_CATALOG_ROLE to peter; 解决了该问题
然后就可以了
以normal身份登录,需要grant SELECT_CATALOG_ROLE to peter授权某个账户即可