Hello together, Is there a manual for the database actions which need

olafn over 9 years ago

Hello together,

Is there a manual for the database actions which need to be done by IBM/our System operator prior to installing the application?
I mean something like : create database; grants etc.

IBM has a database instance for us, but we need rights on it, I guess a simple user name would not be enough, and the rights mentioned in the link before seem not to be detailed enough.
My goal is to have the database prepared for everything – I am not able to directly do any changes in the database, also I am not able do directly influence the installation process.
That means I need to be 100% sure that the installation (and in detail the database part) will work without any issues since every failed installation will cost us time.
So there are 2 points for me which need to be made clear:

1. The prod.properties has the following entries for creating the database connection (one of two current settings):

conf.data.secondary.1...

Discussion posts and replies are publicly visible

Parents

0 olafn over 9 years ago

....jndiname=jdbc/AppianBusinessDS -OK
conf.data.secondary.1.pool-name=MySqlDS
conf.data.secondary.1.class=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
conf.data.secondary.1.security.domain=ds-name-security-business
conf.data.secondary.1.security.username=appian
conf.data.secondary.1.security.passwordhash=xxxxxxxxxxxxxxxxxxxxxxxxxxx
conf.data.secondary.1.driver=com.mysql.jdbc
conf.data.secondary.1.url=jdbc:mysql://localhost:3306/appian_business?useOldAliasMetadataBehavior=true

Since I do not have the documentation here (no PDF) I need an URL, or the correct parameters to prepare everything

2. There are several rights which can be set in an Oracle DB, which ones do we need?
Here are some possibilities:

System Privilege
ADMINISTER ANY SQL TUNING SET
ADMINISTER DATABASE TRIGGER
ADMINISTER RESOURCE MANAGER
ADMINISTER SQL MANAGEMENT OBJECT
ADMINISTER SQL TUNING SET
ADVISOR
ALTER ANY ASSEMBLY
ALTER ANY CLUSTER
ALTER ANY CUBE
ALTER ANY CUBE DIMEN...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 olafn over 9 years ago

....jndiname=jdbc/AppianBusinessDS -OK
conf.data.secondary.1.pool-name=MySqlDS
conf.data.secondary.1.class=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
conf.data.secondary.1.security.domain=ds-name-security-business
conf.data.secondary.1.security.username=appian
conf.data.secondary.1.security.passwordhash=xxxxxxxxxxxxxxxxxxxxxxxxxxx
conf.data.secondary.1.driver=com.mysql.jdbc
conf.data.secondary.1.url=jdbc:mysql://localhost:3306/appian_business?useOldAliasMetadataBehavior=true

Since I do not have the documentation here (no PDF) I need an URL, or the correct parameters to prepare everything

2. There are several rights which can be set in an Oracle DB, which ones do we need?
Here are some possibilities:

System Privilege
ADMINISTER ANY SQL TUNING SET
ADMINISTER DATABASE TRIGGER
ADMINISTER RESOURCE MANAGER
ADMINISTER SQL MANAGEMENT OBJECT
ADMINISTER SQL TUNING SET
ADVISOR
ALTER ANY ASSEMBLY
ALTER ANY CLUSTER
ALTER ANY CUBE
ALTER ANY CUBE DIMEN...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data