| OEM and privilege to see users' schemas [message #451954] |
Mon, 19 April 2010 03:41  |
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 #452179 is a reply to message #452157] |
Tue, 20 April 2010 08:19  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
