In Data Management (DMS), instances in Security Collaboration mode have their system databases blocked during metadata collection. This topic lists the system databases blocked by default for each supported database type.
How it works
After you add an instance to DMS, DMS automatically collects metadata from the databases in that instance. For instances in Security Collaboration mode, DMS excludes system databases from this process to protect them and prevent user interference.
Instances in Flexible Management or Stable Change mode are not affected. DMS collects metadata from all databases in those instances, including system databases.
For more information about metadata, see Metadata.
Limitations
Users with the regular user role cannot query blocked system databases or request permissions to access them. Only administrators and DBAs can query system databases.
To manage user roles, see User management.
Default blocked system databases
The following table lists the system databases that DMS blocks by default for each database type. To change which system databases are blocked, see Customize system databases to block in DMS.
| Database type | Default blocked system databases |
|---|---|
| MySQL: RDS for MySQL, PolarDB for MySQL, MyBase for MySQL, and other MySQL databases<br>MariaDB: RDS for MariaDB and other MariaDB databases | mysql, tmp, sys, __recycle_bin__, innodb<br>test, sbtest<br>information_schema, performance_schema |
| PolarDB Distributed Edition | mysql, test<br>information_schema, performance_schema |
| SQL Server: RDS for SQL Server, MyBase for SQL Server, and other SQL Server databases | master, model, msdb, tempdb, rdscore |
| PostgreSQL: RDS for PostgreSQL, PolarDB for PostgreSQL, MyBase for PostgreSQL, AnalyticDB for PostgreSQL, and other PostgreSQL databases | sys, dbo, information_schema<br>pg_catalog, pgagent |
| PolarDB for PostgreSQL (Compatible with Oracle) | Schemas: sys, dbo, information_schema, msg_prop_t, pg_catalog, pgagent, aq$_agent, aq$_descriptor, aq$_reg_info, dbms_alert, dbms_aq, dbms_aqadm, dbms_crypto, dbms_job, dbms_lob, dbms_lock, dbms_mview, dbms_output, dbms_pipe, dbms_profiler, dbms_random, dbms_redact, dbms_rls, dbms_scheduler, dbms_session, dbms_sql, dbms_utility, utl_encode, utl_file, utl_http, utl_mail, utl_raw, utl_smtp, utl_tcp, utl_url<br>Database: polardb_admin |
| OceanBase Database (MySQL Mode) | mysql, test, oceanbase, information_schema |
| OceanBase Database (Oracle Mode) and Oracle | Schemas: STDBYPERF, READONLY, ANYSQL, DBFLASH, TBSEARCH, MONITOR, MANAGER, ANONYMOUS, SCOTT, IDB_RND, DIP, ORACLE_OCM, OUTLN, DBSNMP, PERFSTAT, SEARCH, TOOLS, TBDUMP, XDB, XS$NULL, SH, PARACHK, ALIHA, MYTEST<br>OPS$ADMIN, B2BDBA, OPERATOR, IDBUSER, IDBADMIN, DEVDBA<br>RND, ERND<br>SYS, SYSTEM, SYSMAN<br>APPQOSSYS, TSMSYS, EXFSYS, WMSYS, DMSYS, CTXSYS, MDSYS, ORDSYS, OWBSYS, OLAPSYS<br>OPSDBA, OPS$ORACLE, OPS$NAGIOS, OPS$OPSDBA |
| DM Database | CTISYS, SYS, SYSAUDITOR, SYSSSO |
| Db2 | None |
| Redis | None |
| MongoDB | admin, local |
| Lindorm-CQL | system, system_auth, system_schema |
| Lindorm-SQL | None |
| Cassandra | system, system_auth, system_cloud, system_distributed, system_schema, system_traces |
| GDB | None |
| AnalyticDB for MySQL 2.0 | None |
| AnalyticDB for MySQL 3.0 | mysql, tmp, sys<br>test, sbtest<br>information_schema, performance_schema<br>innodb, analyticdb |
| DLA | None |
| ClickHouse | system |
| MaxCompute | information_schema |
| Hologres | hologres, hologres_sample, hologres_statistic, hologres_streaming_mv, information_schema, pg_catalog<br>Note By default, schemas are blocked. |