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 typeto Partial makes it a contained database.
For data warehouses on a dedicated SQL instance: anyContainment 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 Partial for Containment type.
Select Options, Partial in Containment type options.