Re: Default schema name

With Oracle 8.1.6, you can now seperate the user account from the schema. This will let you create user accounts which access a different schema by default. For this, you must be at Oracle 8.1.6 and I believe that you will also need to use Oracle Internet Directory (OiD). I have yet to do this myself, but Oracle outlines this in "Getting To Know Oracle 8i", Chapter 2, Section "User/Schema Seperation". You can get a copy of this document on Technet (http://technet.oracle.com).

HTH,
Brian

Jaco Grobler wrote:
>
> Hi All
>
> I would like to know if there are a way to define a default schema name
> other than the users own schema for a userid. I come from a Sybase
> background where you can create a object in the dbo. schema and if no schema
> name are supplied when trying to access the object and the object does not
> exist in the users schema it will go and look for the object in the dbo
> schema
>
> We are busy converting to Oracle but are experiencing problems with trying
> to access objects in a certain schema without specifying the schema name.
> The existing stored procs etc. do not use the schema name and it will be
> quit a lot of work having to place the schema name in front of every object.
>
> TIA
> Jaco Grobler
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================