web stats
MIRTH Connect and Oracle - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2012, 08:40 AM
JNG JNG is offline
What's HL7?
 
Join Date: Oct 2007
Location: Grenoble - France
Posts: 5
JNG
Default MIRTH Connect and Oracle

When modifying the database type in MIRTH Connect Server Manager, it is no more needed to add the "create=true" option at the end of the URL. With version 1.8.2 the privillege granted to the user were limited and the creation of the schema was done through a sql script.
With version 2.1.1, it seems that the creation of the schema is done using an other method, and if the user is not a sysdba, only 5 tables are created (as for an upgrate it seems). This is dangerous even if it is for a short delay (creation of the schema).

Is it possible to know precisely the privileges that must be granted to the user for this schema creation or if special system tables are accessed to identify if the schema must be updated or created ?
Thank you for your help.
Reply With Quote
  #2  
Old 02-22-2012, 06:17 AM
JNG JNG is offline
What's HL7?
 
Join Date: Oct 2007
Location: Grenoble - France
Posts: 5
JNG
Default Mirth Connect and Oracle 11G - a solution

Hi, if the Orcale user is created with the following script, then MIRTH Connect 2.1.1 creates automatically the tables instead of 5 tables only).
Script :
DROP TABLESPACE MIRTHDB INCLUDING CONTENTS AND DATAFILES;
CREATE SMALLFILE TABLESPACE "MIRTHDB"
DATAFILE 'X:\Oracle11G\oradata\INSTANCE\MIRTHDB'
SIZE 100M AUTOEXTEND ON NEXT 50M
MAXSIZE UNLIMITED
LOGGING EXTENT
MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

DROP USER MIRTHDB CASCADE;
CREATE USER "MIRTHDB"
PROFILE "DEFAULT"
IDENTIFIED BY "mirthdb"
DEFAULT TABLESPACE "MIRTHDB"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED ON "MIRTHDB"
ACCOUNT UNLOCK;

GRANT "CONNECT" TO "MIRTHDB";
GRANT "RESOURCE" TO "MIRTHDB";

Any comment on this solution ?
Reply With Quote
Reply

Tags
oracle database, user permission

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:04 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation