Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: referencing objects

Re: referencing objects

From: Louis <frolio_at_videoshare.com>
Date: 2000/03/29
Message-ID: <8btp86$4rt$1@bob.news.rcn.net>#1/1

Thank you both for answering my question. I now understand what can be done regarding this issue.

Louis

Louis wrote in message <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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US