Re: Oracle 10g Express Connection Limitations?

From: Jason D. <Tronman_at_gmail.com>
Date: Wed, 7 May 2008 12:21:03 -0700 (PDT)
Message-ID: <2f278165-960d-425b-b475-e63ad48ff155@f63g2000hsf.googlegroups.com>


On May 7, 12:04 pm, gazzag <gar..._at_jamms.org> wrote:
> 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

Ahh, I see, when I log in in SQL Plus I can see the tables, but I still find it odd that they are not visible in the object browser. Received on Wed May 07 2008 - 14:21:03 CDT

Original text of this message