On May 7, 12:04 pm, gazzag <gar...@[EMAIL PROTECTED]
> wrote:
> On 7 May, 14:32, "Jason D." <Tron...@[EMAIL PROTECTED]
> 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.
|
