Manage Shares with DBMS_SHARE

In addition to the Data Share tool, Autonomous Database supports a fully scriptable workflow via the PL/SQL DBMS_SHARE package.

Using DBMS_SHARE, providers can create and publish shares, add or remove tables and views, register recipients, grant or revoke access, and manage share lifecycle; consumers can discover available shares and programmatically connect to them. The package also exposes producer and consumer views for monitoring and troubleshooting.

If you prefer a guided example, see Implement Data Sharing with PL/SQL.

This LiveLab tutorial walks through enabling a schema for sharing, creating and populating a share, authorizing a recipient, publishing the share, and consuming it - all with DBMS_SHARE calls.

Data Sharing with Python Data Studio APIs for Oracle Autonomous Database

You can also share data using Python Data Studio API for Oracle Autonomous Database.