question about trusted connections

From: Jan van Veldhuizen <jan_at_van-veldhuizen.nl>
Date: Tue, 25 Jan 2005 00:30:53 +0100
Message-ID: <41f584f7$0$12019$e4fe514c@news.xs4all.nl>

Does Oracle support a trusted connection to a database? Without using a pre-defined userid?

In SqlServer, if you have a trusted connection, and you connect as user 'bill', that will be your default prefix for the table. So 'select * from testTable', will look for table bill.testTable. This is the same as with oracle.
In my sqlserver database I used the dbo prefix to be able to find all tables regardless of the current user. Because bill.testTable is not found, the table dbo.testTable will be returned.

How does this work with Oracle? Does it have a 'fallback'? Received on Mon Jan 24 2005 - 17:30:53 CST