Database Containment type Property

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.

Containment types:

For data warehouses on a dedicated SQL instance: any Containment type. None is the default.
For data warehouses on a multi-tenant SQL instance: set Containment type to 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.
Select Properties.
Select Options.
Select Partial for Containment type.

Select **Options**, `Partial` in **Containment type** options.

Notes

https://learn.microsoft.com/en-us/sql/relational-databases/databases/contained-databases?view=sql-server-ver16#partial
- 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