-
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)?
-
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 but...
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.
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
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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?
-
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.
-
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
|