- Plesk Onyx for Windows
You are not logged on as the database owner or system administrator
in SQL Management Studio on attempt to create/modify table, when connection is made under MSSQL user created in Plesk.
DB user has no role db_owner set in its properties
This is an expected behavior. Such setting is not being set by default, when the user is created via Plesk. If the user has this role enabled, it allows to change database size, logs size, etc and overuse limits that have been set in Plesk for subscription or specified in the service plan.
However, the DB user has all required permissions to create/read/write/modify tables permissions and if click OK button, it is possible to continue and create table.