Home » RDBMS Server » Enterprise Manager » OEM and privilege to see users' schemas (OEM, version 10.1.0.2.0 - Windows)
OEM and privilege to see users' schemas [message #451954] Mon, 19 April 2010 03:41 Go to next message
irasgo
Messages: 8
Registered: April 2008
Junior Member
Hello,

I connect to an Oracle-10g database using OEM, and if I click to see the list of users, roles, storage options, ... everything is ok, but if I click to see the list of schemas, I get "1031: insufficient privileges" error.

The user account I use has the SELECT_ANY_DICTIONARY privilege and SELECT_CATALOG_ROLE role granted, and if I try to do "select * from dba_tables" in the SQL*Plus, I get a result.

The matter is even more strange because, if I use the SYSTEM account, I get the same error (!!!).

Do I need any other privilege/role to see the user's schemas with OEM?

Thanks in advance.

Best regards,
Re: OEM and privilege to see users' schemas [message #452157 is a reply to message #451954] Tue, 20 April 2010 06:51 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Post the details

SELECT * FROM DBA_SYS_PRIVS where GRANTEE='&Schema Name'


Babu

[Updated on: Tue, 20 April 2010 06:51]

Report message to a moderator

Re: OEM and privilege to see users' schemas [message #452179 is a reply to message #452157] Tue, 20 April 2010 08:19 Go to previous message
irasgo
Messages: 8
Registered: April 2008
Junior Member
Thanks for your answer.
Executing the code, I get this result (all the privileges without the admin option)

Best regards,


PRIVILEGE
-----------------------------
ALTER ANY CLUSTER
ALTER ANY INDEX
ALTER ANY MATERIALIZED VIEW
ALTER ANY PROCEDURE
ALTER ANY SEQUENCE
ALTER ANY TABLE
ALTER ANY TRIGGER
ALTER ANY TYPE
ALTER SESSION
COMMENT ANY TABLE
CREATE ANY CLUSTER
CREATE ANY INDEX
CREATE ANY INDEXTYPE
CREATE ANY MATERIALIZED VIEW
CREATE ANY OPERATOR
CREATE ANY PROCEDURE
CREATE ANY SEQUENCE
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE PUBLIC SYNONYM
CREATE SESSION
DELETE ANY TABLE
DROP ANY CLUSTER
DROP ANY INDEX
DROP ANY INDEXTYPE
DROP ANY MATERIALIZED VIEW
DROP ANY OPERATOR
DROP ANY PROCEDURE
DROP ANY SEQUENCE
DROP ANY SYNONYM
DROP ANY TABLE
DROP ANY TRIGGER
DROP ANY TYPE
DROP ANY VIEW
DROP PUBLIC SYNONYM
EXECUTE ANY PROCEDURE
INSERT ANY TABLE
LOCK ANY TABLE
SELECT ANY DICTIONARY
SELECT ANY TABLE
UNLIMITED TABLESPACE
UPDATE ANY TABLE
Previous Topic: OEM not starting
Next Topic: Listener is down
Goto Forum:
  


Current Time: Thu Mar 28 07:12:54 CDT 2024