Re: Oracle 10g Express Connection Limitations?

On 7 May, 14:32, "Jason D." <Tron..._at_gmail.com> wrote:
> It's for a summer research project at university I worked on last
> summer and am continuing my research this summer. I'm basically
> working on multi-database querying, I've been experimenting mainly
> with Oracle, MySQL and Postgres for the time being. I've never used
> synonym's before but I googled them to get the basics. I noticed the
> owner for V$SESSION is 'public' but I still can't see it in the object
> Browser (I can however see it when I log in on the command line/SQL
> Plus). So anyway I queried V$SESSION but it didn't tell me anything
> new, a extra tuple gets added showing my application connected when it
> is, and then the tuple disappears when my application disconnects!

V$SESSION is a public synonym (as opposed to a private one) and is therefore potentially visible to all users of the database, providing that the relevant user has been granted SELECT privilege on the underlying table, in this case V_$SESSION.

HTH -g Received on Wed May 07 2008 - 10:04:11 CDT