Re: Oracle vs. SQL Server

On 14 Apr 2003 11:00:21 -0700, rhennessy_at_qumas.com (Richard Hennessy) wrote:

>Does Oracle have a feature similar to SQL Server's "Inital Catalog"
>connection string attribute, which directs all queries to the tables
>of the specified database?

[snip]
>I know I can qualify each table name with the owner but I don't want
>to use this if possible due to problems encountered previously.
>
>Ideally, I would like an attribute that I could include as part of my
>ADO connection string that would direct the queries for that session
>to look at a particluar users tables, enabling me to do away with
>public synonyms?

 Private synonyms as Sybrand says, or alternatively alter session set current_schema = whatever;

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_22a.htm#2079951

 You could put this in an after logon trigger if you can't issue it from the app straight after the connect.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)