Hi , How to execute the following statements in Cayenne. Trying to access Oracle schema using different account having select permission.
SET ROLE browse_japan; ALTER SESSION SET CURRENT_SCHEMA = JAPAN; Regards, basu Note in JDBC I can execute the following it works . Connection connection = dataSource.getConnection(); connection.createStatement().execute("SET ROLE browse_japan"); connection.createStatement().execute("ALTER SESSION SET CURRENT_SCHEMA = JAPAN");