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)?
Printable View
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)?
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;
Thanks for the tip but what does this privilege grant the user? And where can I find out about other privileges?
'select any dictionary' privilege grants the user access to the dictionary tables.
You could start with the oracle docs for starters. This will give you a better idea about what privileges do.Quote:
And where can I find out about other privileges?
You can also query dba_sys_privs to get a list of all the privileges
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?
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.
Thanks for the help