hbar
Member²
I'm using version 6.0.3.893. I've seen this happen a few times, and I just now figured out what sequence of events makes this happen. If you open the sessions window (tools -> sessions) whilst you are logged in, things work fine. And should you try to open the sessions window whilst you are not logged in, you'll find it quite impossible, as the option is dimmed.
But say you are logged in, and you open the sessions window. Then, at a later time, your connection is dropped for some reason (but not because you logged out). Not thinking, you attempt to refresh the sessions window, only to get the (seemingly strange) error stating that "To view session information you must have access to the v$session view" which I suppose makes sense, since a non-logged in user technically doesn't have those rights, but wouldn't a "you're not logged in, moron" error make more sense? Probably, but that's not what I came to tell you about.
If you then log back in and refresh the sessions window, you'll find 2 strange things:
1. there are no column names
2. there are extra/different/differently ordered columns shown
If you open another sessions window, you'll find the "correct" version is shown. Odd, indeed. It's certainly not a show stopper, but it's not right, either.
So there you go.
But say you are logged in, and you open the sessions window. Then, at a later time, your connection is dropped for some reason (but not because you logged out). Not thinking, you attempt to refresh the sessions window, only to get the (seemingly strange) error stating that "To view session information you must have access to the v$session view" which I suppose makes sense, since a non-logged in user technically doesn't have those rights, but wouldn't a "you're not logged in, moron" error make more sense? Probably, but that's not what I came to tell you about.
If you then log back in and refresh the sessions window, you'll find 2 strange things:
1. there are no column names
2. there are extra/different/differently ordered columns shown
If you open another sessions window, you'll find the "correct" version is shown. Odd, indeed. It's certainly not a show stopper, but it's not right, either.
So there you go.
