title: how to create security while we connect to oracle database from sas
body: <pre><code> %let user=scott;
   %let password=tiger;
  
  libname ora oracle user=&amp;user password=&amp;password;
  
   options mprint mlogic symbolgen;
  
   dm log 'clear';
  </code></pre>
  
  <p>in this way can we provide security to database?
  so, i am trying to make security for my connection, if i clear my log that no one can see it.but once i close my sas section the library which i created will be vanished, so, can u please  help me to create permanent library in order to make sure there is a connection with oracle after the section has closed.  </p>