dbactions:
      type: SoftwareComponent
      parameters:
        configs:
          - actions: [CREATE]
            name: createSchema
            config: 
              'Fn::Base64':
                'Fn::Join':
                  - "\n"
                  -
                    - scriptFile=~/createSchema.sh
                    - scriptLog=~/createSchema.log
                    - rm -f ${scriptFile}
                    - touch ${scriptFile}
                    - touch ${scriptLog}
                    - echo "sqlplus / as sysdba << EOF" >> ${scriptFile}
                    - echo "drop user c##myappuser cascade;" >> ${scriptFile}
                    - echo "create user c##myappuser identified by ${schemaPassword};" >> ${scriptFile}
                    - echo "grant create session, create table, unlimited tablespace to c##myappuser;" >> ${scriptFile}
                    - echo "quit" >> ${scriptFile}
                    - echo "EOF" >> ${scriptFile}
                    - sh ${scriptFile} >> ${scriptLog}
            runAsUser: oracle
            timeout: 1
            continueOnFailure: false