SQLcl: MCP Server & SQL Prompt

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!

SQLcl 25.2 export of ORDS REST Modules apply filters

Ajax_ords2 hours ago

Hi All,

I am on 25.22 sqlcl and I am using project export to move objects across environments.

I have two schemas where objects and grants are given on based objects to be referred by one another.

When I am connected to Schema_A then during project export it also exports table which have been enabled in ords_schema under SchemaB.

I modified project filters to apply constraints but it doesn't work (export_type = 'ORDS_SCHEMA' and owner = 'SchemaA'),
SCHEMAB_STATUS_TYPES table exists in SchemaB and exposed as ORDS in SchemaB only.

ORDS_METADATA.ORDS.ENABLE_OBJECT(

  p\_enabled => TRUE,

  p\_schema => 'SCHEMA',

  p\_object => 'SCHEMAB\_STATUS\_TYPES',

  p\_object\_type => 'TABLE',

  p\_object\_alias => 'access-req-status-types',

  p\_auto\_rest\_auth => FALSE);

Am I missing something, how can I only limit ORDS to expose those objects which are owned by that schema only ?

Thanks, Ajax

Added 2 hours ago

0 comments

4 views