Change the default schema to dbo for users created in Plesk (MSSQL)
Should be possible to change the default schema for that user directly from Plesk to do not be needed to do it manually every time to install the specific app on a database
Anonymous
shared this idea
Upd: Sorry, we are closing the request as no information were provided for over a month.
—
IG
-
Michael Jenkins commented
This remains an issue. Specifically in MSSQL, security is split between LOGIN and USER. Most small to medium scale MSSQL implementations use a single schema that should be [dbo]. In Plesk, when a new user is setup, the user can be assigned to a database. But Plesk assigns the new user to a schema that has the same name as the user. It should assign the user's default schema to be dbo unless specified otherwise.
-
Kuzma
commented
It causes issue with a deployment process and it is required to manually go and change the schema in SQL server from the Plesk user schema to DBO.