Subject Re: [firebird-support] Firebird 2.0.1 can't use roles ?
Author Thomas Steinmaurer
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