--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...>
wrote:

>
> Hi Marc,
>
> > 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.

> >
> > I need roles identification, due to my own replication engine.
>
> - The role must exist
> - The connected user must be a member of this role
> - The role must be specified at connect time
>
> Only then, CURRENT_ROLE will give you the expected result.
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>

Thanks Thomas. I had not specified the user as a member of the role (I
thinked it not was necessary for SYSDBA user). Now it connects perfectly.