Hi all,

I want to use roles to identify users (in views/procedures) maintained
by a client application.


These "users" are not reflected by database users, every login is
performed with SYSDBA, because sometimes the database is transferred
to a tablet PC and used with embedded FB access (no chance to
install a server).


I have created a new ROLE with

CREATE ROLE 'uid1';

SELECT * FROM RDB$ROLES; returns "uid1".


The connection string is:
CONNECT 'e:\testdb.fdb' USER 'SYSDBA' PASSWORD 'MASTERKEY' ROLE 'uid1';

But the role is not returned by
SELECT CURRENT_ROLE FROM RDB$DATABASE;

Every attempt results in "NONE".


I have tried this with Firebird 2.0.4 Win32 embedded, 2.0.5 embedded
and 2.0.5 SuperServer (yes, for the server I've used the correct
fbclient.dll).

Are roles supported in embedded mode?



Any suggestions how to get roles working?


Daniel




--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)