Properties props = new Properties(); props.setProperty("javax.net.ssl.keyStore", "/path/to/keystore"); props.setProperty("javax.net.ssl.keyStorePassword", "keystore_password"); props.setProperty("javax.net.ssl.trustStore", "/path/to/truststore"); props.setProperty("javax.net.ssl.trustStorePassword", "truststore_password"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//host:port/service_name", props); Properties props = new Properties(); props.setProperty("user", "db_username"); props.setProperty("password", "db_password"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//host:port/service_name", props); String sql = "SELECT * FROM users WHERE username = ?"; PreparedStatement stmt = conn.prepareStatement(sql); stmt.setString(1, inputUsername); ResultSet rs = stmt.executeQuery(); sql CREATE ROLE role_name; GRANT SELECT, INSERT, UPDATE, DELETE ON table_name TO role_name; GRANT role_name TO username;