| hiding sqlplus password [message #5622] |
Tue, 25 February 2003 02:42  |
A.C.Dey
Messages: 5
Registered: November 2002
|
Junior Member |
|
|
i have an application developed in d2k where desktop is having an icon to run the application. in the icon property the following command is written:
c:orawin95binifrun60.exe fas.fmx fasuser/faspwd@mclhq
where fas.fmx is the main application form,
fasuser is the user name of fas, faspwd is the password, mclhq is the host string to connect to the database.
if any user right clicks on the icon, the he can see the username and password for fas user. how can i restrict users from seeing this password, so that they can't get sql prompt and change table contents from back end. Is there a way by which I can avoid writing username and password to connect to the sql.
plz help me
thanx in advance
|
|
|
|
| Re: hiding sqlplus password [message #5623 is a reply to message #5622] |
Tue, 25 February 2003 03:13  |
Avinash Pai
Messages: 23
Registered: February 2003
|
Junior Member |
|
|
Hi Dey,
U can hide ur password by writing code as
logon('username','password'||'@'||'hoststring');
in the ON-LOGON trigger at form level in ur main application form "fas.fmb"
Here
username = user name of ur database,
password = password,
hoststring = host string to connect to ur database.
I hope this will serve ur purpose.
Best regards,
Avinash Pai
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
