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

Thread: logging in

  1. #1
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26

    logging in

    If scott is a user created by default, why can't I log into OEM 9i as scott or hr(I've unlocked that account)?

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    we've had this topic a couple of times on this forum.

    You need to have select any dictionary privilege granted to connect thru OEM.
    So, in your case, you need to grant
    Code:
    select any dictionary to scott;

  3. #3
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26

    Thanks but...

    Thanks for the tip but what does this privilege grant the user? And where can I find out about other privileges?

  4. #4
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    'select any dictionary' privilege grants the user access to the dictionary tables.

    And where can I find out about other privileges?
    You could start with the oracle docs for starters. This will give you a better idea about what privileges do.

    You can also query dba_sys_privs to get a list of all the privileges

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26

    But...

    I now know what the privilege does but why is it needed? Isn't it possible to log in as scott and have access to his schema objects alone?

  7. #7
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    OEM is more of a DBA tool from Oracle. So, you need to have certain privileges to log on through OEM. You can always view your schema objects using sql plus or any other available tools like TOAD etc.
    IF you have more questions as to why again, I think you must address that to Oracle itself cos they might be ale to help you better in this respect.

  8. #8
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26
    Thanks for the help

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