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.

See unresolvable-reference.html#GUID-C3412C5B-4267-49EF-BB78-C05E647DF2B6 for more information.

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. See Data Studio Data Share API functions for more information.