Re: bypassing logon screen

Date sent: 18-JAN-1996 08:46:14

Fred,

You can use the ON-LOGON trigger to create your own log-on process. I have used it and it works reasonably well.

In this trigger, I have used the LOGON package to log-onto an Oracle database. The only negative I have seen is that I was unable to use it twice within the same trigger(with a LOGOFF command between).

Tom

>
>I have a Forms 4.5 application, which when I run it as a run-time
>application, the first thing that the user sees is the Oracle logon prompt,
>asking them for their username, password, and database to connect to. My
>question is, is there any way to default the database name they see, or to
>bypass this screen and display my own logon screen to them? We have several
>databases they could connect to, and they may not know the correct name to
>enter.
>
>Any help would be greatly appreciated.
>
>Fred Gamache
>fgamache_at_gic.gi.com

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%                                                                            %
% Tom Mercadante                                                             %
% Database Administrator                                                     %
% SUNY Plattsburgh                                                           %
%                                                                            %
% BITNET   : MERCADTF_at_SNYPLAVB.BITNET                                        %
% INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU      Computer Systems Center %
% PHONE    : (518)564-3013                           Kehoe 507               %
% FAX      : (518)564-4415                           Plattsburgh, NY 12901   %
%                                                                            %
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%