documentation icon indicating copy to clipboard operation
documentation copied to clipboard

MS SQL user should not be in sysadmin group to use non-default schema

Open knstvk opened this issue 5 years ago • 1 comments

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.

knstvk avatar Sep 03 '19 14:09 knstvk

The custom schema should be defined in the user's "Default schema". In this case, the tables are created there, not DBO.

image

IskandarovRost avatar Feb 19 '20 08:02 IskandarovRost