--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > I am connecting to a new Firebird 2.0.1 database, and I can not

use roles.

> >
> > I get not error during connection using a role, but a 'select
> > current_role from rdb$database' ever gets a NONE result (like a
> > 'select rdb$get_context('SYSTEM', 'CURRENT_ROLE') from rdb$database').
> >
> > I have tried to connect using Borland dbExpress (Delphi 6), FibPlus
> > 6.1, and IB-Expert. In all of them, current_role variable indicates
> > that no role is used.
> >
> > What can I do to solve that ?
> >
> > Database could be a clean Firebird 2.0.1 database, newly created (with
> > only the role addeded), and client I nused is Firebird 2.0.1

fbclient.dll.

>
> Have you granted the role to the user you are connecting with ?
> Did you specify that role during connection ?
>
> Ivan
>

Thank you Ivan, the problem was the grantings. I don't expected I
needed any grant, because I was using SYSDBA user.

I have addeded grant REPLICATION to SYSDBA; and now it runs like a charm.