Regression - trusted role does not work with version 3.0.10

[pwbzh]

Hello,

Tested on GNU/Linux and Windows, the Mapping of Users to Objects does not work with version 3.0.10 but works with version 3.0.7

https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-mapping.html

Thanks

[AlexPeshkoff]

Doubt that:

# ./isql -user sysdba -pas masterkey localhost:employee
Database: localhost:employee, User: SYSDBA
SQL> select current_user from rdb$database;

USER
===============================
SYSDBA

SQL> create mapping sysg using * from user sysdba to user guest;
SQL>

# ./isql -user sysdba -pas masterkey localhost:employee
Database: localhost:employee, User: GUEST
SQL> select current_user from rdb$database;

USER
===============================
GUEST

SQL>

[pwbzh]

GRANT SELECT ON TEST TO ROLE SALE;
CREATE MAPPING ROLE_JDOE USING PLUGIN SRP FROM USER JDOE TO ROLE SALE;

The user JDOE can execute the SELECT on the table TEST in 3.0.7, not in 3.0.8 and next.
After testing, the problem occurs in 3.0.8.
Overwriting the SRP DLL and the main executable from 3.0.8 with those of from 3.0.7 works.

[pwbzh]

The problem seems to come from the engine12 DLL between version 3.0.7 and 3.0.8.

[AlexPeshkoff]

That's not mapping by itself (current_role is correct) problem but something bad with trusted role. Will fix.

[AlexPeshkoff]

An issue is specific for 3.0.x, no need front-porting.