Oracle Cloud Infrastructure Documentation

List Table Hyperlinks, Groups, and Group Members

You can list the active Table Hyperlinks, Table Hyperlink Groups, and Table Hyperlink Group members.

Parent topic: Use Table Hyperlinks for Read Only Data Access on Autonomous Database

List Table Hyperlinks and Table Hyperlink Groups

You can list the active Table Hyperlinks that you generated on an Autonomous Database instance and the ADMIN user can list all active Table Hyperlinks. The listing of Table Hyperlinks includes Table Hyperlink Groups.

Run DBMS_DATA_ACCESS.LIST_ACTIVE_URLS to list the active Table Hyperlinks and Table Hyperlink Groups. For example: 

DECLARE    
    result CLOB;
    BEGIN
       result := DBMS_DATA_ACCESS.LIST_ACTIVE_URLS;           
       dbms_output.put_line(result);
    END;
/

This example shows the following output:

[{"id":"pT36lYHFGA4s3UXSNBCRO13v3D4_example1",
"created_by":"SCOTT",
"service_name":"HIGH",
"expiration_time":"2025-07-28T16:38:02.723Z",
"expiration_count":10,
"access_count":0,
"created":"2025-04-29T16:38:02.977Z",
"inherit_acl":true,
"sql_statement":"select * FROM TREE_DATA WHERE COUNTY = :county"}]

When a Table Hyperlink list entry is a Table Hyperlink Group, the "is_group_url" shows with the value true. For example: 

{
"id":"vnns6DhPUBXyB1bzUtTOoPUcqnDcpplRo_example",
"created_by":"SCOTT",
"service_name":"HIGH",
"expiration_time":"2025-09-04T15:36:39.355Z",
"expiration_count":10,
"access_count":0,
"created":"2025-06-06T15:36:39.377Z",
"is_group_url":true,
"group_ids":[null]
}
Note

When the is_group_url value is true, this indicates a Table Hyperlink id is a Table Hyperlink Group.

See LIST_ACTIVE_URLS Function for more information.

List Table Hyperlink Group Members

You can list the members of a Table Hyperlink Group.

Note

To list the members of a Table Hyperlink Group you need to provide the Table Hyperlink Group id.

Run DBMS_DATA_ACCESS.LIST_MEMBERS to list Table Hyperlink Group members.

For example:

DECLARE
    status CLOB;
    BEGIN
       DBMS_DATA_ACCESS.LIST_MEMBERS(
         id => 'aGnHVyZ4vBo4_Fq2R0A2G2-y6TdUKRHeveqyGJ3_example',
         result => status);           
      dbms_output.put_line(status);
    END;
/

This shows the following output:

{ "members" :
  [
    {"id" : "lVy_kJnm5MzO1EGBYBvdcaYark5waukv7V59wObq5RDS2Z2AlzEh_DmaboSNeCfR", "schema_name" : "admin", "schema_object_name" : "employee", "name" : "employee", "description" : "employee description"},
    {"id" : "8L5QWWVDB3NrGu-NLx6Q-k-1EsP6jxmjednfMxgrbVFolPipNNDbL1rIt2Ywwprc", "sql_statement" : "select * from admin.tree", "name" : "tree", "description" : "tree description"}
  ]
}

See LIST_ACTIVE_URLS Function and LIST_MEMBERS Procedure for more information.

Notes for Listing Table Hyperlinks and Table Hyperlink Groups

Provides notes for listing Table Hyperlinks and Table Hyperlink Groups.

Notes for running DBMS_DATA_ACCESS.LIST_ACTIVE_URLS:

  • The behavior of DBMS_DATA_ACCESS.LIST_ACTIVE_URLS is dependent on the invoker. If the invoker is ADMIN or any user with PDB_DBA role, the function lists all active Table Hyperlinks, regardless of the user who generated the Table Hyperlink. If the invoker is not the ADMIN user and not a user with PDB_DBA role, the list includes only the active Table Hyperlinks generated by the invoker.

  • When you generate and list a Table Hyperlink on an Autonomous Database instance with a private endpoint, the result includes a name private_preauth_url with the value of the form: "https://private-endpoint/adb/p/parurl-token/data".

    When you generate and list a Table Hyperlink on an Autonomous Database instance with a private endpoint and the private endpoint is configured with Allow public access enabled, the result includes both the preauth_url for the public endpoint and private_preauth_url.

    See Configure Private Endpoints and Use a Private Endpoint with Public Access Allowed for more information.

  • When a Table Hyperlink is a group member the DBMS_DATA_ACCESS.LIST_ACTIVE_URLS response entry shows "group_ids" with a non-null value that includes one or more IDs. The IDs show Table Hyperlink Group IDs that the Table Hyperlink (group member) is a member of.