Re: question about trusted connections

Jan van Veldhuizen wrote:
> 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'?
>
>

You might consider ORACLE operating system authentication to be close to this. So If I login to the operating system as bill, I then connect to the database using "/" as the login and Oracle treats me as if I logged in as the user named bill. And my default schema of course be bill.

dbo? not dba?

Anyway, look this all up in the Administrators guide, Auththentication.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost