Forwarded to devs Migration DB Username for more than one assignments

[destan40]

TITLE:

Migration DB Username than has more then one assignments dont work​

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:

Plesk 17.8.11, CentOS, cPanel​

PROBLEM DESCRIPTION:

Problem1
I tried to localy to migrate a user from cPanel
case example:

Systemusername: user589
Databases: user579_db1, user579_db2
DB_User: user579_user
Assignments:
user579_user-> user579_db1
user579_user-> user579_db2
(One User assigned to two databases)

Problem after migrating:
user579_db1 have a assigned user=user579_user, Correct
user579_db2 have not assigned user, Not correct

Problem 2
Editing Migrated DB User Rights etc. not possible, because
Database user name is forced with beginning syntax "admin_" like:
admin_user579_user
​

STEPS TO REPRODUCE:

Migrating user from cpanel that have more then one databases and one user is assigned to many databases​

ACTUAL RESULT:

migrated databases have not assigned dbuser, so not usable​

EXPECTED RESULT:

assigning dbuser correctly​

ANY ADDITIONAL INFORMATION:

​

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:

Help with sorting out​

 

[IgorG]

This is Plesk limitation: it is not possible to assign one user to several databases, there are only 2 options:

1. Assign user to one db
2. Assign user to all databases

 

[Aleksey Filatev]

Database user name is forced with beginning syntax "admin_" like

Database and database users prefixes policy could be managed at Tools & Settings / Database Hosting Preferences.