webMethods Product Suite  | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products | Preparing for Database Component Creation | Database User and Storage, and Database Settings | Database User
 
Database User
You can create one database user for multiple database components, or you can create a different database user for each database component. Later sections in this chapter explain how to create database users.
The table below lists the permissions the database user must have and the file in which to specify those permissions.
RDBMS
Path to File
DB2
Software AG_directory \common\db\scripts\db2\storage\30\create\db2_str_c_ddl_user.sql
MySQL Community Edition
Software AG_directory \common\db\scripts\mysql\storage\30\create\mys_str_c_ddl_user.sql
MySQL Enterprise Edition
Software AG_directory \common\db\scripts\mysql\storage\30\create\mys_str_c_ddl_user.sql
Oracle
Software AG_directory \common\db\scripts\oracle\storage\25\create\ora_str_c_ddl_user.sql
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.
SQL Server
Software AG_directory \common\db\scripts\mssql\storage\30\create\mss_str_c_ddl_user.sql
Copyright © 2007-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.