It must be possible to clear the command line buffer using a
command at the command prompt or from a script, but I can not find it in the
documentation.
I have a need for users to run a script that logs into a
database to retrieve data into a dataframe, but I need some way to keep the
password from persisting on screen or in a file for security reasons.
I doubt that there is any way to hide the input to
readline() as it is typed at the command line, but it would make things more
secure if I could clear the screen buffer right after importData has finished.
# test.ssc
mynewdata <-
importData(
type="direct-oracle",
user="DB_USER",
password=readline(prompt="Enter
password at prompt in command window: "),
server="BIGDATABASE",
sqlQuery =
"SELECT 'foo' AS foo_bar FROM dual"
)
This came up 9-years ago on this list, but it has not been
answered. I opened a service request with Tibco for this. I will post their response
if I get one.
Thanks very much.
- Doug
Douglas Hersh
Environmental Quality Department
Massachusetts Water
Resource Authority
100 First Ave. Boston MA 02129
email: douglas daht hersh ayaht
mwra.state.ma.us
http://www.mwra.state.ma.us/harbor/html/bhrecov.htm