True. Two users logged in with the same ID to the same connection will see
the same data. This is usually a desirable feature. For security purposes,
most transaction systems require users doing updates to connect using
different usernames. Multiple users of the same name is sometimes allowed
for reporting, but here two reports run at the same time should produce the
same results.
do, I could be
Enterprises
<A%5%.231$H9.153939_at_news2.teleport.com>,
<NOSPAM_ryang_at_teleport.com_NOSPAM> wrote:
However, I've just discovered that these synonyms are not scoped to the
connection.
using the
>
> San Jose, CA, USA
<6hiiko$ps$1_at_nnrp1.dejanews.com>...
to what Jeremy is saying: In
files and memory area under thecontrol of a
the Instance. In order to gainaccess to any
database, you must log on (connect)to that
you provide your userid/passwordand a connect string
the database to which you want toconnect. Once you are
database, you look at tables in your ownschema by default.
Oracle refers to a set of database objectswhich have the same
Hence, if I am logged on as RONO, myschema is RONO. Your schema
ROBERTY. We can eachhave a set of tables with the same name, for
RONO.EMPLOYEE andROBERTY.EMPLOYEE. To reference your own schema,
only refer to the table by name: EMPLOYEE. There a two methods
>access someone else's schema.One is the notation I used above
>(RONO.EMPLOYEE). The other option is to create a synonym. A synonym is
>just a way to tell Oracle that when Isay this, I really mean that. Hence,
>if ROBERTY had no EMPLOYEE tablehe could reference RONO.EMPLOYEE by
creating
you say
usage? If
tables,
tables one time, and
vs. Production)
clarified more than confused
Interlude EnterprisesIn article
jeremyr_at_techie.com wrote:> > Rob,
almost like user's, in> one Oracle
"connect" statement,> switch between
each user. Or, you> can set up completely
database files and> choose between the database
Oracle SID> (System IDentifier). The first style
description of SQL Server ... hope that helps a
you running Oracle?> > Jeremy Russell> >
<NOSPAM_ryang_at_teleport.com_NOSPAM> wrote:> > >We are porting
Server 6.5 to Oracle 7.3 and are quite> >confused, as you might
please bear with me 8)> >> >There is a concept in SQL Server of
databases on a given> >server which can contain the same schema
stored procedures, etc.).> >When connecting with DB-Lib, the
can be used to set the> >desired default database, so that SQL
like> >"Select Name from My_Table" can be executed.> >> >However,
see how to do this with OCI or even Embedded SQL.> >It would seem
database name must be specified for non-default> >databases, e.g.
Name from MyDatabase.MyTable".> >> >
Leader in Internet Discussion ==-----
offering spam-free web-based newsreading
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Apr 22 1998 - 08:18:07 CDT
