Use the following rules and guidelines when you set up the user
The database user account must have permissions to create and drop tables, indexes, and views, and to select, insert, update, and delete data from tables.
Use 7-bit ASCII to create the password for the account.
To prevent database errors in one repository from affecting any other repository, create each repository in a separate database schema with a different database user account. Do not create a repository in the same database schema as the domain configuration repository or any other repository in the domain.