?
Solved

isql access using an encrypted password

Posted on 2004-08-16
3
Medium Priority
?
2,046 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Assisted Solution

by:Jan Franek
Jan Franek earned 400 total points
ID: 11810458
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 600 total points
ID: 11810733
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
ID: 11819205
Thanks,

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

0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

770 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