View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004015 | SymmetricDS | Task | public | 2019-06-19 11:56 | 2019-08-26 12:56 |
Reporter | ialnahrawy | Assigned To | elong | ||
Priority | normal | ||||
Status | closed | Resolution | won't fix | ||
Summary | 0004015: Switch to another DB user (Oracle) | ||||
Description | Dear Team, I need to change the database user to use another user which has all privilege to access to the same schema . when I change the configuration to use the new user , SymmetricsDS tries recreate the sys tables , and I got the following error , is there a way to switch to another user without recreate for the sys tables 2019-06-19 14:57:19,855 WARN [headoffice-000] [OracleSymmetricDialect] [symmetric-startup] DDL failed: CREATE TABLE "SYM_CHANNEL".. 2019-06-19 14:57:19,855 ERROR [headoffice-000] [AbstractSymmetricEngine] [symmetric-startup] An error occurred while starting SymmetricDS org.jumpmind.db.sql.SqlException: ORA-00955: name is already used by an existing object at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:417) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:330) Thanks, | ||||
Steps To Reproduce | Update db.user and db.password on engine/*.properties New user has all privileges to access the db schema | ||||
Tags | dialect: oracle | ||||
|
I haven't seen that done before -- on Oracle, the user login determines the "schema" where tables will be created. SymmetricDS uses sys_context('USERENV', 'CURRENT_SCHEMA') as the default schema where SYM tables are created. If you can change the schema returned by that function, you might be able to switch users. You might be able to force the schema with a parameter like this: db.init.sql=alter session set current_schema=oldschema; |
Date Modified | Username | Field | Change |
---|---|---|---|
2019-06-19 11:56 | ialnahrawy | New Issue | |
2019-06-19 12:30 | elong | Assigned To | => elong |
2019-06-19 12:30 | elong | Status | new => feedback |
2019-06-19 12:30 | elong | Note Added: 0001535 | |
2019-06-19 12:30 | elong | Tag Attached: dialect: oracle | |
2019-08-26 12:56 | admin | Status | feedback => closed |
2019-08-26 12:56 | admin | Resolution | open => won't fix |