Re: [Squirrel-sql-users] Squirrel SQL Oracle OS authentication

On Fri, Oct 15, 2004 at 10:16:43AM +0200, Magerman, Tom wrote:
> We are using Oracle database 10G with OS user authentication, and
> everything runs well with SLQ*Plus and Microsoft Access (ODBC linked
> tables).
> 
> We are looking for a SQL front end, more user-friendly than SQL*Plus,
> less overhead then Microsoft Access. I tested Squirrel and it looks
> great.
> 
> One problem, how to connect as OS authenticated user? I use Oracle OCI
> driver, but I cannot log on if I leave user or password blanc (it's a
> problem I encounter with a lot of SQL front ends).
> 
> Any ideas? Logging on as OS authenticated user is crucial to us.

From a quick googling it may be possible to use OS authentication by
passing null for the user and password. I'll need to modify SQuirreL to
do this so it should happen in the next beta.

-- 
Colin Bell
http://www.squirrelsql.org