This is the mail archive of the cygwin mailing list for the Cygwin project.
Index Nav: | [Date Index] [Subject Index] [Author Index] [Thread Index] | |
---|---|---|
Message Nav: | [Date Prev] [Date Next] | [Thread Prev] [Thread Next] |
Other format: | [Raw text] |
Hello Thomas... almost; the security hole has changed to a very tiny one with your new script;
Noted and already accounted for
- was just avoiding confusing the actual issue
The way I approach this is as follows Create a directory e.g. .myconns in my home directory with 700 chmod permission In my .profile (or equivalent)
export SQLORACLE"=${ORACLE_HOME}\\bin\\sqlplus.exe -s /NOLOG " export CONNHOME=${HOME}/.myconns REPCONNFILE=${CONNHOME}/.connrep.sql; echo conn myuser/mypass@mydbhost> ${REPCONNFILE} chmod 600 ${REPCONNFILE} export mydbconn="${SQLORACLE} @${REPCONNFILE}";
so in the .myconns directory is the connection string - the /NOLOG switch prevents sqlplus from actually trying to connect from the shell command level. the relevant connection is picked up in the REPCONNFILE
so a ps will only ever show the value (path) of the REPCONNFILE so I can reuse new existing database darter
...
Thomas Wolff-3 wrote:
Am 15.09.2010 19:18, schrieb delbydev:
Hello Have hunted all over for this one but it seems no one else has reported the issue - maybe because they don't use the feature or there is something awry with my installation
I write scripts that dart in and out of databases
I bind my Oracle connection string into a number of variables in my .profile
ORACLE_HOME='c:\\Oracle\\product\\11.2.0\\dbhome_2' export ORACLE_HOME mydbconn="${ORACLE_HOME}\\bin\\sqlplus -s mydbuser/mydbpass@mydbhost" export mydbconn
so when I want to dart into the database - I perform the following from
the
terminal command line
${mydbconn}
...
Not answering your question (others did), but be aware: It is a very, very bad idea in general to place a password on the command line because every user on your machine can see your password. Do this on your home machine for testing only. ------ Thomas
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
-- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Index Nav: | [Date Index] [Subject Index] [Author Index] [Thread Index] | |
---|---|---|
Message Nav: | [Date Prev] [Date Next] | [Thread Prev] [Thread Next] |