Home

Welcome to the DBS wiki!

How to create a DBS server to a database

1. Ask DBS to create a set of db accounts.

• cms_x_y_owner
• cms_x_y_admin
• cms_x_y_writer
• cms_x_y_reader You may define x or y to whatever is meaningful to you. The important here is that you have four accounts: owner, admin, writer and reader.

2. edit https://github.com/dmwm/DBS/blob/master/Schema/DDL/create-oracle-schema.sql You need to edit this file to create new roles and assign them the accounts you ask the DBA created for you. Note you have to modify the create-oracle-schema.sql to get unique roles for your database. Fail to do so, the script will not run.
3. Logging to the cms_x_y_owner account and run create-oracle-schema.sql.
4. Prepare the db secrets file. dbs3_ig_i2 = {'connectUrl' : { 'reader' : 'oracle://cms_x_y_reader:pd1', 'writer' : 'oracle://cms_x_y_writer:pd2' }, 'databaseOwner' : 'cms_x_y_owner' }