Never create your own database tables in the same schema or database as a Software AG database component.

Software AG strongly recommends using the Database Component Configurator to create database storage, tablespaces, and filegroups, and to create database users for all RDBMSs, with two exceptions (see below). If you must instead create these objects manually (for example, because of security requirements), go to the Software AG_directory /common/db/DCC/Storage/scripts/release/RDBMS directory, open the RDBMS_str_c_ddl_user.sql file, and grant the permissions listed in that file.

You can create one database user for multiple database components, or you can create a separate database user for each database component.

You can create all database components in the same storage, or you can create each database component in its own storage.

For Oracle and Tibero, Software AG scripts require ALTER SESSION permission at the time of creating database tables. You can revoke this permission after the tables have been created.

The table below shows the storage convention that all Software AG database components follow by default. You can use a different convention when you create storage. (For PostgreSQL there are no storage conventions and tablespaces are not used.)