-
select any dictionary privilege
Hi,
I'm trying to connect to OEM as the SYSTEM user but I received an error message saying that system should be granted.
"select any dictionary privilege"
Isn't the SYSTEM user supposed to have this privilege?
NOTE:
Database is 9.2.0.4
Oracle client is 9i
Can any one explain this?
-
DAMN!!
I KNOW I had this problem before and I forgot the fix. Did you try doing what it said? Can't hurt.
MH
I remember when this place was cool.
-
Re: select any dictionary privilege
Originally posted by clinton
Hi,
I'm trying to connect to OEM as the SYSTEM user but I received an error message saying that system should be granted.
"select any dictionary privilege"
Isn't the SYSTEM user supposed to have this privilege?
NOTE:
Database is 9.2.0.4
Oracle client is 9i
Can any one explain this?
The behavior changed in 9i
I'm stmontgo and I approve of this message
-
the "07_DICTIONARY_ACCESIBILITY init.ora paramter will fix this but it will leave you open to a security violation.
Description : Used primarily
for migration
from Oracle7 to Oracle8i. If TRUE, SYSTEM privileges, such as
SELECT ANY
TABLE, do not restrict access to objects in the SYS schema
(Oracle7 behavior). If FALSE, users can only access objects
in the SYS schema when granted the SELECT_CATALOG_ROLE,
EXECUTE_CATALOG_ROLE, or DELETE_CATALOG_ROLE.
Range of Values: TRUE | FALSE
Default Value : TRUE
Stick to granting the priv and you should be ok.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|