Subject | Firebird 2.0.1 can't use roles ? |
---|---|
Author | marc_guillot |
Post date | 2007-04-03T10:29:15Z |
Hello.
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.
Thank you in advance.
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.
Thank you in advance.