DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: select any dictionary privilege

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    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

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    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
  •  


Click Here to Expand Forum to Full Width