Solved

isql access using an encrypted password

Posted on 2004-08-16
3
1,798 Views
Last Modified: 2011-09-20
Hi,

Is there any way to use isql with an encrypted password ?

so with the command "isql -Uuser -Ppassword" been executed from a shell script, "password" would be encrypted - is this possible ?
0
Comment
Question by:HowardNZ2003
3 Comments
 
LVL 14

Assisted Solution

by:Jan_Franek
Jan_Franek earned 100 total points
Comment Utility
According to isql reference on http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/util/@ebt-link;pt=1092;lang=cs?target=%25N%15_15937_START_RESTART_N%25
you should use -X command line option:

-X
initiates the login connection to the server with client-side password encryption. isql (the client) specifies to the server that password encryption is desired. The server sends back an encryption key, which isql uses to encrypt your password, and the server uses the key to authenticate your password when it arrives.
0
 
LVL 6

Accepted Solution

by:
ChrisKing earned 150 total points
Comment Utility
are you trying to encrypt the tunnel of communincations from the client to the server

order the password itself (from the OS) ?

if the latter, then try
isql -Sserver -Uuser -i script.sql < ~/.password

the ~/.password file contains the password for "user" and has been secured with: chmod 700 ~/.password
0
 

Author Comment

by:HowardNZ2003
Comment Utility
Thanks,

it was actually how to hide the password at the OS level but all input was valuable.

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now