Solved

isql access using an encrypted password

Posted on 2004-08-16
3
1,886 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
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 150 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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