Skip to main content
Skip table of contents

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

  1. Obtain exclusive access to the database.

  2. Right-click the database name in SSMS Object Explorer panel.

  3. Select Properties.

  4. Select Options.

  5. Select Partial for Containment type.

Select Options, Partial in Containment type options.

Notes


Keywords: multiple users, creating data warehouse, contained database, partially contained database, partially contained database, Contained database user

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.