Re: referencing objects

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/29
Message-ID: <954352243.1531.2.pluto.d4ee154e_at_news.demon.nl>#1/1


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
>
>
You can use public synonyms to do that. Create public synonym <synonym name> for <object owner>.<object_name>

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Mar 29 2000 - 00:00:00 CEST

Original text of this message