Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
8 subscribers
Views
2787 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
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...
OriginalPostID-142224
OriginalPostID-142224
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