title: firebird user with granted privileges cannot access tables
body: <p>I created a Firebird user (PIPPO) via jaybird, follows gsec &quot;display&quot;:</p>
  <pre class="lang-none prettyprint-override"><code>GSEC&gt; di
       user name                    uid   gid admin     full name
  ------------------------------------------------------------------------------------------------
  SYSDBA                              0     0           Sql Server Administrator
  PIPPO                               0     0           GesAll 1.0 User
  GSEC&gt;
  </code></pre>
  <p>I create a role (GESALLDB_USER) in Firebird DB and granted some privileges:</p>
  <pre><code>SQL&gt; show grant;
  
  /* Grant permissions for this database */
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ANELLI TO ROLE GESALLDB_USER
  
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON COPPIE TO ROLE GESALLDB_USER
  
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON COVE TO ROLE GESALLDB_USER
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON DATI_CONFIGURAZIONE TO ROLE GESALLDB_USER
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON DATI_COVE TO ROLE GESALLDB_USER
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON DATI_SOGGETTI TO ROLE GESALLDB_USER
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON DEPOSIZIONI TO ROLE GESALLDB_USER
  GRANT GESALLDB_USER TO PIPPO
  SQL&gt;
  </code></pre>
  <p>I granted this role to the new user via jaybird (last line before):</p>
  <p>The problem is that whenever I try to run a query, I get the message:</p>
  <pre><code>SQL&gt; select * from anelli;
  Statement failed, SQLSTATE = 28000
  no permission for read/select access to TABLE ANELLI
  SQL&gt;
  </code></pre>
  <p>If I grant directly the TABLE to the newly created user everything works.</p>
  <pre><code>SQL&gt; grant all on anelli to pippo;
  SQL&gt; show grant;
  
  /* Grant permissions for this database */
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ANELLI TO ROLE GESALLDB_USER
  
  GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ANELLI TO USER PIPPO
  
  SQL&gt; connect &quot;C:\Users\teiluke\Documents\Ondulati\DB\prova\gesalldb.fdb&quot; user &quot;p
  ippo&quot; password &quot;topolino&quot;;
  Commit current transaction (y/n)?y
  Committing.
  Server version:
  WI-V2.5.2.26540 Firebird 2.5
  WI-V2.5.2.26540 Firebird 2.5/XNet (E7441EA1CA2CF4)/P12
  WI-V2.5.2.26540 Firebird 2.5/XNet (E7441EA1CA2CF4)/P12
  Database:  &quot;C:\Users\teiluke\Documents\Ondulati\DB\prova\gesalldb.fdb&quot;, User: pi
  ppo
  SQL&gt; select * from anelli;
  </code></pre>
  <pre class="lang-none prettyprint-override"><code> PROGRESSIVO FEDERAZIONE RNA    TIPO   ANNO         INIZIO         FINE ATTIVA
    LAST_USED
  ============ =========== ====== ====== ====== ============ ============ ====== =
  ===========
             1 FOI         89LR   E      2012              1          100 N
            0
             2 FOI         89LR   E      2013              1          100 S
           41
  </code></pre>
  <p>Any help on this?</p>