Re: How to test a connect string user/password@instance without actually doing the connect

Home -> Community -> Usenet -> c.d.o.server -> Re: How to test a connect string user/password@instance without actually doing the connect

From: Al <al_at_work>
Date: Tue, 28 Apr 1998 10:46:13 -0400
Message-ID: <6i4qcu$b0f4@piper.ncr.pwgsc.gc.ca>

Yes, but then you are issuing a connect using the database link.

The user/password_at_instance can not be completely tested unless you actually try the connect.

You could attempt a "connect junk/wrong_pass_at_instance" in order to verify that the database is active, by generating an ORA-01017: invalid username/password. Obviously this does not validate the username & password combination.

rk16 wrote in message <6hqt25$sts$1_at_news.online.de>...
>The only option you have is to create a database link (DDL) for the
username
>and password and then "select 1 from dual_at_db-link".
>
>Regards Reimar
>
>Freddy Knoll schrieb in Nachricht
><353F35C3.1C6D4A67_at_software-kompagniet.com>...
>>Is it possible to test a connect string user/password_at_instance without
>>actually doing the connect ?
>>
>>Regards,
>>Freddy Knoll
>>
>
>
Received on Tue Apr 28 1998 - 09:46:13 CDT