Re: referencing objects

Sorry,
strongly disagree about that. It is extreemly BAD practice to do that. You are loosing transparency. Whenever you want to maintain a development and production scheme, you can easily do that by using private and public synonyms.
When you hardcode the schema owner, you'r stuck forever, and you end up setting up a second istance, which makes things only more difficult.

Regards,

Sybrand Bakker, Oracle DBA

Rob Calfee <trace_at_primenet.com> wrote in message news:8btd7o$9jq$1_at_nnrp02.primenet.com...
> Louis,
>
> I'll be honest. It is always a good coding policy to use the schema prefix
> in all PL/SQL development because of the problem you just discussed. This
> should come natural to any PL/SQL developer because the policy only makes
> sense because it identifies the location of objects which helps future
> coders (every company has that revolving door of employees) pick up where
> the last coder left off. You should start the policy now of coding in the
> schema prefix. This will only help in the future. Then you can give
 rights
> on internet to inet and you will be finished.
>
> Rob Calfee
> Systems Consultant
> Quest Software
> 602-741-9419
> 520-421-2734/7124
> rcalfee_at_quest.com
> www.quest.com
>
>
>
> Louis <frolio_at_videoshare.com> wrote in message
> news:8bt8kk$k5f$1_at_bob.news.rcn.net...
> > Greetings All, I have created an Oracle 8i database that is to
> > be used on a web database server. I have created a schema
> > called "internet" and have been creating objects(tables, procedures,
> > etc.) in this schema. Now, I have created a user called "inet" which
> > will be the default user that will connect to the database via the web
> > server.
> > My question is this: When the web team designs their web pages and
> > they go to reference a procedure in the "internet" schema do they need
> > to preface the procedure call with the schema name? For example:
> > internet.spProcedure. Is it possible to have the login user "inet" call
> > the procedure without prefacing it with the schema name? For example:
> > spProcedure. I ask this because we are coming off a SQL server database
> > and all the object where compile under the dbo user and in this case
 when
> > a procedure call takes place from the web server the schema name is not
> > needed. It is my hope to mimic this in Oracle so that our web team does
 not
> > have to go through all their code to add the schema name to each
 procedure
> > call.
> >
> > Any help would be greatly appreciated.
> >
> > Yours, Louis
> >
> > frolio_at_videoshare.com
> >
> >
>
>
Received on Wed Mar 29 2000 - 00:00:00 CEST