title: How to create a derby user
body: <p>I tried to set the DB schema name by schema.xml but it caused a schema name duplication in the generated SQL statement for ID generators. (<a href="https://stackoverflow.com/questions/35834001/duplicate-schema-name-in-sequece-generation">Duplicate schema name in sequece generation</a>)</p>
  
  <p>I read the schema is defined by the passed user at connection time. Now I would like to set the schema by this way.</p>
  
  <p>But I don't know how can I create a new Derby user and link it with the desired schema. Can somebody help me?</p>
  
  <p>Environment: NetBeans, Glassfish, Derby</p>
  
  <p>I have found this:</p>
  
  <pre><code>CALL SYSCS_UTIL.SYSCS_CREATE_USER('username', 'password')
  </code></pre>
  
  <p>But Derby answers:</p>
  
  <pre><code>Error code -1, SQL state 42Y03: 'SYSCS_UTIL.SYSCS_CREATE_USER' is not recognized as a function or procedure.
  </code></pre>
  
  <p>Why? I have connected to the db as the default admin user.</p>
  
  <p>Or if I try to dispatch this command from a GUI tool, Derby says:</p>
  
  <pre><code>[Error Code: 0, SQL State: 42Y07] : Schema 'SYSCS_UTIL' does not exist
  </code></pre>