title: How to grant DBSA equivalent rights to OS user on non-root Informix installation?
body: <p>For a <strong>non</strong>-root Informix v11.7 installation created by <code>user1</code>, <code>user1</code> impliclitly is granted DBSA rights.</p>
  
  <p>How to grant <code>user2</code> the equivalent rights as <code>user1</code>, that are DBSA rights? </p>
  
  <p><code>user2</code> shall be able to </p>
  
  <ul>
  <li>toggle the DB-server between single user- and online-mode (<code>onmode -j/-m</code>)</li>
  <li>run the <code>dbexport</code> and <code>dbimport</code> tools.</li>
  </ul>
  
  <p>Both user accounts (<code>user1</code> and <code>user2</code>) are OS user accounts.</p>
  
  <hr>
  
  <p><strong>Update:</strong></p>
  
  <p>The <code>$INFORMIXDIR</code>-tree is owned by <code>user1:group1</code> and <code>user2</code> is member of <code>group1</code>.</p>
  
  <p>If <code>user2</code> runs <code>onmode/dbexport/dbimport</code> as mentioned above, the following error message is issued (roughly):</p>
  
  <p><code>onmode -j</code> and <code>onmode -m</code> return:</p>
  
  <pre><code>Must be a DBSA to run this program
  </code></pre>
  
  <p><code>dbexport "db@dbs" -c -q -ss</code> and <code>dbimport -c -q -i . "db@dbs"</code> return:</p>
  
  <pre><code>-1809 - Server rejected the connection.
  </code></pre>
  
  <p>and the log file shows:</p>
  
  <pre><code>00:00:00  Reject connection - 12
  00:00:00  Error: Local user validation failed.
  </code></pre>