I have downloaded SQL Developer Early adopter 4.0.
I want to know if it is possible to control and check properties of tablespace of my user on DB.
Thanks all for collaboration,
View | DBA shows the DBA pane which allows you to manage the database, if you have the appropriate priveleges.
I have tried but every time it gives me error.
So I think I haven't the appropiate privileges.
It is strange, because when I used TOAD I was able to check tablespaces....
How can I solve this?
What exactly are you trying to do when you get the error, and what is the error message?
Under DBA Panel, then Memory and then Tablespace. I double click on tablespace icon and then I receive this error:
I translate from italian:
ORA-00942: table o view does not exist
I can reproduce your error with a user who does not have 'SELECT ANY DICTIONARY' privilege.
but in TOAD I have not this type of problem, and the user is the same...
So the solution is to have select any dictionary privilege, isn't it?
Yes that is the solution.
I don't know what queries toad uses internally, and why it requires different privileges.
Ok, thanks for your collaboration!
SELECT ANY DICTIONARY would be the easiest way to 'fix' the user's issue, but you could also grant selects on the required data dictionary views as needed.