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
|
