I want to conect oracle form 6i to oracle 10g data base
Oracle 10g, Oracle 6i, Oracle Database, Oracle Database 11g SQL Fundamentals I, Oracle Forms, Oracle Forms 6i
I want to connect Oracle form6i fmx to oracle 10g data base
presently i am connecting at client side making shortcut in path i use to write :C:orantBINifrun60.EXE c:MSFORMSERP_LOGIN erp_ss/ss@sdcl
in this method End user is knowing User name and password and connecting string.
Is there any other method i can hide this connection from end user
Software/Hardware used:
Software/Hardware used:
ASKED:
March 20, 2009 12:14 PM
UPDATED:
March 20, 2009 2:48 PM
Answer Wiki:
You could create some kind of INI file, in which you put the user, password and connect string encrypted.
Then your ERP_LOGIN form could read this file, decrypt the data, and use the logon built-in to connect to the database. This database user should be a user with just read privileges on some security-related tables, against which you will validate the login credentials provided by the user. Then you could use the logout and logon built-ins to re-connect to the database with the appropriate user.
See Forms help for information on how to use the logout and logon built-in procedures.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
