You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An unprivileged user (as in: newly created, nothing explicitly granted), is unable to see their own context variables in MON$CONTEXT_VARIABLES.
Steps to reproduce:
1. As SYSDBA create a new user:
create user someuser password 'somepassword';
2. Connect to a database with that user:
connect 'localhost:e:/db/somedatabase.fdb' user someuser password 'somepassword';
3. Add a context variable
select rdb$set_context('USER_SESSION', 'owned_by_someuser', 'true') from rdb$database;
4. Query MON$CONTEXT_VARIABLES
select mon$attachment_id, mon$transaction_id, mon$variable_name, mon$variable_value from mon$context_variables;
Expected: 1 row with variable name 'owned_by_someuser' and value 'true'
Actual behaviour: no row shown
Firebird 3.0.6 behaves as expected.
The text was updated successfully, but these errors were encountered:
Submitted by: @mrotteveel
An unprivileged user (as in: newly created, nothing explicitly granted), is unable to see their own context variables in MON$CONTEXT_VARIABLES.
Steps to reproduce:
1. As SYSDBA create a new user:
create user someuser password 'somepassword';
2. Connect to a database with that user:
connect 'localhost:e:/db/somedatabase.fdb' user someuser password 'somepassword';
3. Add a context variable
select rdb$set_context('USER_SESSION', 'owned_by_someuser', 'true') from rdb$database;
4. Query MON$CONTEXT_VARIABLES
select mon$attachment_id, mon$transaction_id, mon$variable_name, mon$variable_value from mon$context_variables;
Expected: 1 row with variable name 'owned_by_someuser' and value 'true'
Actual behaviour: no row shown
Firebird 3.0.6 behaves as expected.
The text was updated successfully, but these errors were encountered: