• State Not Answered
  • Replies 7 replies
  • Subscribers 10 subscribers
  • Views 2668 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

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

olafn
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

  • 0
    ....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...
  • 0
    ...SION
    ALTER ANY DIMENSION
    ALTER ANY EDITION
    ALTER ANY EVALUATION CONTEXT
    ALTER ANY INDEX
    ALTER ANY INDEXTYPE
    ALTER ANY LIBRARY
    ALTER ANY MATERIALIZED VIEW
    ALTER ANY MINING MODEL
    ALTER ANY OPERATOR
    ALTER ANY OUTLINE
    ALTER ANY PROCEDURE
    ALTER ANY ROLE
    ALTER ANY RULE
    ALTER ANY RULE SET
    ALTER ANY SEQUENCE
    ALTER ANY SQL PROFILE
    ALTER ANY TABLE
    ALTER ANY TRIGGER
    ALTER ANY TYPE
    ALTER DATABASE
    ALTER DATABASE LINK
    ALTER PROFILE
    ALTER PUBLIC DATABASE LINK
    ALTER RESOURCE COST
    ALTER ROLLBACK SEGMENT
    ALTER SESSION
    ALTER SYSTEM
    ALTER TABLESPACE
    ALTER USER
    ANALYZE ANY
    ANALYZE ANY DICTIONARY
    AUDIT ANY
    AUDIT SYSTEM
    BACKUP ANY TABLE
    BECOME USER
    CHANGE NOTIFICATION
    COMMENT ANY MINING MODEL
    COMMENT ANY TABLE
    CREATE ANY ASSEMBLY
    CREATE ANY CLUSTER
    CREATE ANY CONTEXT
    CREATE ANY CUBE
    CREATE ANY CUBE BUILD PROCESS
    CREATE ANY CUBE DIMENSION
    CREATE ANY DIMENSION
    CREATE ANY DIRECTORY
    CREATE ANY EDITION
    CREATE ANY EVALUATION CONTEXT
    CREATE ANY IN...
  • 0
    ... DEX
    CREATE ANY INDEXTYPE
    CREATE ANY JOB
    CREATE ANY LIBRARY
    CREATE ANY MATERIALIZED VIEW
    CREATE ANY MEASURE FOLDER
    CREATE ANY MINING MODEL
    CREATE ANY OPERATOR
    CREATE ANY OUTLINE
    CREATE ANY PROCEDURE
    CREATE ANY RULE
    CREATE ANY RULE SET
    CREATE ANY SEQUENCE
    CREATE ANY SQL PROFILE
    CREATE ANY SYNONYM
    CREATE ANY TABLE
    CREATE ANY TRIGGER
    CREATE ANY TYPE
    CREATE ANY VIEW
    CREATE ASSEMBLY
    CREATE CLUSTER
    CREATE CUBE
    CREATE CUBE BUILD PROCESS
    CREATE CUBE DIMENSION
    CREATE DATABASE LINK
    CREATE DIMENSION
    CREATE EVALUATION CONTEXT
    CREATE EXTERNAL JOB
    CREATE INDEXTYPE
    CREATE JOB
    CREATE LIBRARY
    CREATE MATERIALIZED VIEW
    CREATE MEASURE FOLDER
    CREATE MINING MODEL
    CREATE OPERATOR
    CREATE PROCEDURE
    CREATE PROFILE
    CREATE PUBLIC DATABASE LINK
    CREATE PUBLIC SYNONYM
    CREATE ROLE
    CREATE ROLLBACK SEGMENT
    CREATE RULE
    CREATE RULE SET
    CREATE SEQUENCE
    CREATE SESSION
    CREATE SYNONYM
    CREATE TABLE
    CREATE TABLESPACE
    CREATE TRIGGER
    CREATE TYPE
    CREATE USER
    C...
  • 0
    ... REATE VIEW
    DEBUG ANY PROCEDURE
    DEBUG CONNECT SESSION
    DELETE ANY CUBE DIMENSION
    DELETE ANY MEASURE FOLDER
    DELETE ANY TABLE
    DEQUEUE ANY QUEUE
    DROP ANY ASSEMBLY
    DROP ANY CLUSTER
    DROP ANY CONTEXT
    DROP ANY CUBE
    DROP ANY CUBE BUILD PROCESS
    DROP ANY CUBE DIMENSION
    DROP ANY DIMENSION
    DROP ANY DIRECTORY
    DROP ANY EDITION
    DROP ANY EVALUATION CONTEXT
    DROP ANY INDEX
    DROP ANY INDEXTYPE
    DROP ANY LIBRARY
    DROP ANY MATERIALIZED VIEW
    DROP ANY MEASURE FOLDER
    DROP ANY MINING MODEL
    DROP ANY OPERATOR
    DROP ANY OUTLINE
    DROP ANY PROCEDURE
    DROP ANY ROLE
    DROP ANY RULE
    DROP ANY RULE SET
    DROP ANY SEQUENCE
    DROP ANY SQL PROFILE
    DROP ANY SYNONYM
    DROP ANY TABLE
    DROP ANY TRIGGER
    DROP ANY TYPE
    DROP ANY VIEW
    DROP PROFILE
    DROP PUBLIC DATABASE LINK
    DROP PUBLIC SYNONYM
    DROP ROLLBACK SEGMENT
    DROP TABLESPACE
    DROP USER
    ENQUEUE ANY QUEUE
    EXECUTE ANY ASSEMBLY
    EXECUTE ANY CLASS
    EXECUTE ANY EVALUATION CONTEXT
    EXECUTE ANY INDEXTYPE
    EXECUTE ANY LIBRARY
    EXECUTE ANY ...
  • 0
    ... OPERATOR
    EXECUTE ANY PROCEDURE
    EXECUTE ANY PROGRAM
    EXECUTE ANY RULE
    EXECUTE ANY RULE SET
    EXECUTE ANY TYPE
    EXECUTE ASSEMBLY
    EXEMPT ACCESS POLICY
    EXEMPT IDENTITY POLICY
    EXPORT FULL DATABASE
    FLASHBACK ANY TABLE
    FLASHBACK ARCHIVE ADMINISTER
    FORCE ANY TRANSACTION
    FORCE TRANSACTION
    GLOBAL QUERY REWRITE
    GRANT ANY OBJECT PRIVILEGE
    GRANT ANY PRIVILEGE
    GRANT ANY ROLE
    IMPORT FULL DATABASE
    INSERT ANY CUBE DIMENSION
    INSERT ANY MEASURE FOLDER
    INSERT ANY TABLE
    LOCK ANY TABLE
    MANAGE ANY FILE GROUP
    MANAGE ANY QUEUE
    MANAGE FILE GROUP
    MANAGE SCHEDULER
    MANAGE TABLESPACE
    MERGE ANY VIEW
    ON COMMIT REFRESH
    QUERY REWRITE
    READ ANY FILE GROUP
    RESTRICTED SESSION
    RESUMABLE
    SELECT ANY CUBE
    SELECT ANY CUBE DIMENSION
    SELECT ANY DICTIONARY
    SELECT ANY MINING MODEL
    SELECT ANY SEQUENCE
    SELECT ANY TABLE
    SELECT ANY TRANSACTION
    SYSDBA
    SYSOPER
    UNDER ANY TABLE
    UNDER ANY TYPE
    UNDER ANY VIEW
    UNLIMITED TABLESPACE
    UPDATE ANY CUBE
    UPDATE ANY CUBE BUILD PROCESS...
  • 0
    ...
    UPDATE ANY CUBE DIMENSION
    UPDATE ANY TABLE
    Many thanks in advance,

    Mit freundlichen Grüßen, Kind Regards, Pozdrawiam,


    David Gabrysch
    IT-Systemingenieur
    ALD AutoLeasing D GmbH
    IT - Infrastructure
    Nedderfeld 95, 22529 Hamburg
    Postfach 57 03 28, 22772 Hamburg
    Tel. +49(0)40471047729
    Fax. +49(0)40471047439
    David.Gabrysch@aldautomotive.com
    www.aldautomotive.de
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.