Creating users and schemas for SQL Server databases
You must create the users and schemas after creating the SQL Server databases.
Before you begin
Assign the IBM® Business Process Manager database
user to the following three roles:
Note: The database must be created
by the database administrator who can then assign these roles to the
database users for IBM Business Process Manager.
- db_ddladmin
- db_datawriter
- db_datareader
Important: For
all database users, note the following restrictions:
- The user cannot be assigned to the system administrator (SYSADMIN) role.
- The user must be mapped to the master database with the SqlJDBCXAUser role.
Important: In Microsoft SQL server,
the default schema name associated with a user must be the same as
the user name. For example, if the user name for the Performance Data
Warehouse database is dbuser then the default schema
name associated with the user dbuser must also
be named dbuser. You must create an ordinary database
user and assign the required rights to the user instead of using a
super user, such as sa or the user who created
the database (the database owner). This is because the default schema
for the super user is dbo and this cannot be
changed.
About this task
When using Windows authentication, you must ensure that the domain account is added to the SQL Server login. You must login as the SQL Server administrator and follow the below steps to create users and schemas.
Procedure
What to do next
When you create database schemas using the generated scripts, your user ID must have the authority to create tables. When the tables are created, you must have the authority to select, insert, update, and delete information in the tables. For information about the database privileges that are needed to access the data stores, see the topic SQL Server database privileges.