title: How to hide SQL Plus password in Python script
body: <p>I created Python script which truncate Oracle table. I use SQL Plus, but the problem is that I have to hide password which is plain text now. I have arguments like these:</p>
  
  <pre><code>db_name = "DB_NAME"
  db_user = "DB_USER"
  db_password = "DB_PASS"
  </code></pre>
  
  <p>Then I run command like:</p>
  
  <pre><code>sqlplus_delete_table = 'echo "TRUNCATE TABLE ' + db_user + '.' + table + ' DROP STORAGE;"'
  sqlplus_connection = db_user + '/' + db_password + '@' + db_name
  os.system(sqlplus_delete_table + ' | sqlplus -s ' + sqlplus_connection)
  </code></pre>
  
  <p>Everything works fine, but the problem is password. As I know, SQL Plus does not use jceks files. So what are other solutions to hide password?</p>