Privileges for Microsoft SQL Server
To automatically create schemas, tables, and views while you deploy monitor models and enable data movement services, or when you remove a monitor model, grant db_owner authority to the user-specified authentication alias for Monitor_Admin_Database. If the authentication alias that is associated with the Monitor_Admin_Database does not have db_owner authority, you must manually create the database schema to install monitor models and enable data movement services.
The following table describes the scope of the database grants that are required for the user who is specified in the Monitor_Database authentication alias.
| Database privilege | Scope |
|---|---|
| SELECT | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| INSERT | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| UPDATE | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| DELETE | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| EXECUTE | All stored procedures in the monitor model schema |