From a user-access standpoint, a contained database is a database that is isolated from other databases and from the SQL Server instance that hosts the database. A user in a contained database cannot access other databases nor the SQL instance, the user only exists in that contained database. Setting a database’s
Containment type to
Partial makes it a contained database.
For data warehouses on a dedicated SQL instance: any
Noneis the default.
For data warehouses on a multi-tenant SQL instance: set
Partial. With this setting, you can add users with access to this, and only this, database.
How to Change Containment type
Obtain exclusive access to the database.
Right-click the database name in SSMS Object Explorer panel.
Partialfor Containment type.
In a contained database there is a boundary between a database and the instance of SQL Server and other databases.
A Non-contained database is a database that has containment set to NONE.
https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver16 Use contained database users to authenticate SQL Server and SQL Database connections at the database level.
Keywords: multiple users, creating data warehouse, contained database, partially contained database, partially contained database, Contained database user