Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ORA-01031: insufficient privileges when trying to run ords.enable_schema

Mark Sta AnaJun 6 2017 — edited Jun 7 2017

I've been able to get ORDS standalone (connected to Database A) running locally via SQL Developer. I'm now trying to install it (connected to Database B) using instructions provided by Tim Hall's excellent resource: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode

I've also checked the install against the following instructions: Installing Oracle REST Data Services

When I try to enable rest service for a schema on Database B. I get the following error.

So far the only difference I can tell between this install and the ORDS install for Database A  is my chosen schema has a proxied user to ORDS_PUBLIC_USER. So I tried to mimic this on Database B using alter user my_schema grant connect through ORDS_PUBLIC_USER;

I've run java -jar ords.war validate and can see no errors in the log.

I even tried create an admin user java -jar ords.war user adminlistener "Listener Administrator" so I could use the REST Data Services > Admininistration feature. I've connected to the ORDS on Database B, but when I right click on Database B in the Connections panel there's no Enable REST services.

Comments

MoC

Can you increase the font size instead of scaling the Text?

-fx-font-size: 2.0em;

This would fix the issue, I think.

user8929955

The StackPane will center everything you put into it. Use a Group instead.

NikolayArtamonov

Yes, it will fix the issue, but I need proportional scaling of text relative to size of stack pane. By the way, size of stack pane isn't fixed and may change on some conditions. It's hard to do with font size, that's why I use scaleX/Y properties.

MoC
Answer

You could try wrapping the Text in a Group. I tested in Scene Builder and it seemed to work ok with different StackPane alignments:

<?xml version="1.0" encoding="UTF-8"?>

<?import java.lang.*?>

<?import java.util.*?>

<?import javafx.scene.*?>

<?import javafx.scene.layout.*?>

<?import javafx.scene.paint.*?>

<?import javafx.scene.text.*?>

<StackPane alignment="TOP_LEFT" prefHeight="230.0" prefWidth="335.0" style="" xmlns:fx="http://javafx.com/fxml/1" xmlns="http://javafx.com/javafx/2.2">

  <children>

    <Group id="Group">

      <children>

        <Text layoutX="-29.0" layoutY="-11.0" scaleX="2.0" scaleY="2.0" strokeType="OUTSIDE" strokeWidth="0.0" text="Text" />

      </children>

    </Group>

  </children>

</StackPane>

Marked as Answer by NikolayArtamonov · Sep 27 2020
shakir.gusaroff

Hi. Try the following:

text.setTextAlignment(TextAlignment.LEFT);

StackPane.setAlignment(Pos.CENTER);

NikolayArtamonov

Thank you very much, MoC! Wrapping text to group gracefully solved the problem! )

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2017
Added on Jun 6 2017
4 comments
1,622 views