Issue Details (XML | Word | Printable)

Key: CORE-4743
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Maxim Kuzmin
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Granted role does not work with non-ascii username

Created: 09/Apr/15 10:10 AM   Updated: 14/Sep/15 12:52 PM
Component/s: None
Affects Version/s: 2.5.4
Fix Version/s: 3.0 Beta 2

QA Status: Deferred
Test Details: Config parameter 'UserManager' need to be = 'Srp'. Currently all tests run under 'Legacy_UserManager'.


 Description  « Hide
We using a user names in native, russian language. But using granted role not possible.
Example:
1. Executing GRANT USER_ROLE TO "DOMAIN\ПОЛЬЗОВАТЕЛЬ".

2. Work through isql:
c:\Program Files (x86)\Firebird\Firebird_2_5\bin>isql -ch win1251 -r user_role -tr
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect server:some_path_to_db.fdb;
Database: server:some_path_to_db.fdb, Role: USER_ROLE
SQL> select mon$user, mon$role from mon$attachments;

MON$USER MON$ROLE
=============================== ===============================
DOMAIN\ПОЛЬЗОВАТЕЛЬ NONE

If using user name in english language, its work - in MON$ROLE - USER_ROLE.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 18/Apr/15 06:27 AM
Maxim, please try 3.0 windows snapshot build (hope it will be ready for 20 od April).
With login/password authentication I get:

localhost bin # ./isql -user польз -pass 123 -role somerole localhost:employee
Database: localhost:employee, User: польз, Role: SOMEROLE
SQL> select mon$user, mon$role from mon$attachments;

MON$USER MON$ROLE
=============================== ===============================
ПОЛЬЗ SOMEROLE


Maxim Kuzmin added a comment - 19/Apr/15 10:06 AM
Alex, now OK. I connected through TA (russian username) with custom role and it be used.
Patch for 2.5 wil be applied?

Alexander Peshkov added a comment - 22/Apr/15 02:43 PM
What about 2.5 - dumb backport does not work, and I do not think it's worth seriously changing stable branch.