documentation
documentation copied to clipboard
MS SQL user should not be in sysadmin group to use non-default schema
Environment
- Documentation version: 7.0
- Part of the documentation: Manual
- Existing page: https://doc.cuba-platform.com/manual-7.1/db_schema_connection.html
Description of the bug or enhancement
MS SQL docs:
The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of dbo.
The custom schema should be defined in the user's "Default schema". In this case, the tables are created there, not DBO.