Ability to select database schema when creating database users in Plesk for MSSQL
It is required to import databases created externaly with dbo database schema.
When such database imported in Plesk it is assigned to schema of the database user created in Plesk. When user created in Plesk, new schema is created for database user. For example, user test1 created in Plesk will have database schema "test1"
This results to the non-functional Database due to wrong schema (reuqired dbo, while database imported with schema test1).
The suggestion is to add functionality to select schema when creating database users in Plesk
Plesk Tech Support
shared this idea
Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.
—
IG
-
Chad Clarke commented
This would be very helpfull for us since we need the users default schema to be dbo as well.