Oracle Cloud Infrastructure Documentation

DBMS_DATA_ACCESS_ADMIN Package

The DBMS_DATA_ACCESS_ADMIN package provides administrative routines generate and manage Table Hyperlinks for data sets.

Parent topic: Autonomous AI Database Supplied Package Reference

DBMS_DATA_ACCESS_ADMIN Overview

Describes the use of the DBMS_DATA_ACCESS_ADMIN package.

DBMS_DATA_ACCESS_ADMIN procedures control users who can define creation scopes for Table Hyperlinks and users who can create federated tables on remote schemas or objects.​They let you grant or revoke a user’s ability to register scopes and to read from specific remote schemas or schema objects when creating federated tables.

DBMS_DATA_ACCESS_ADMIN Security Model

DBMS_DATA_ACCESS_ADMIN is a definer rights PL/SQL package.

By default, the EXECUTE privilege on this package is granted to ADMIN and PDB_DBA, without the GRANT option.

Summary of DBMS_DATA_ACCESS_ADMIN Subprograms

This section covers the DBMS_DATA_ACCESS_ADMIN subprograms provided with Autonomous AI Database.

Subprogram Description

GRANT_REGISTER

This procedure allows you to control which users in a Provider Autonomous AI Database can register or modify a scope.

REVOKE_REGISTER

This procedure revokes the privileges to register or update a creation scope.

GRANT_READ

This procedure creates a Federated table.

REVOKE_READ

This procedure revokes the creation of a federated table.
  • GRANT_REGISTER Procedure
    This procedure allows users to manage creation scopes. Only these privileged users can register, update, or unregister scopes.
  • REVOKE_REGISTER Procedure
    This procedure revokes the privileges to register or update a creation scope.
  • GRANT_READ Procedure
    This procedure grants specific users the right to create federated tables against remote provider schemas or objects.
  • REVOKE_READ Procedure
    This procedure revokes user's privilege to create a federated table.

Parent topic: DBMS_DATA_ACCESS_ADMIN Package

GRANT_REGISTER Procedure

This procedure allows users to manage creation scopes. Only these privileged users can register, update, or unregister scopes.

Syntax

procedure grant_register(
username in varchar2,
scope in varchar2
);

Parameters

Parameter Description

username

Name of the user whom you want to grant the privilege.
scope

Specifies the level of access control for Table Hyperlinks.

REVOKE_REGISTER Procedure

This procedure revokes the privileges to register or update a creation scope.

Syntax

procedure revoke_register(username in varchar2);

Parameters

Parameter Description

username

Name of the user for which you want to revoke the privilege.

GRANT_READ Procedure

This procedure grants specific users the right to create federated tables against remote provider schemas or objects.

Syntax

procedure grant_read(
    username                  in varchar2,
    remote_schema_name        in varchar2,
    remote_schema_object_name in varchar2 default null);

Parameters

Parameter Description

username

Specifies the name of the user for which you want to grant the privilege.
remote_schema_name

Specifies the name of the remote schema you want to access.

remote_schema_object_name

Specifies the name of the remote schema object name you want to access. If you do not specify this field all objects in the mentioned schema can be accessed.

REVOKE_READ Procedure

This procedure revokes user's privilege to create a federated table.

Syntax

   procedure revoke_read(
     username                  in varchar2,
     remote_schema_name        in varchar2,
     remote_schema_object_name in varchar2 default null);

Parameters

Parameter Description

username

Specifies the name of the user for which you want to revoke the privilege.
remote_schema_name

Specifies the name of the remote schema you want to revoke.

remote_schema_object_name

Specifies the name of the remote schema object name you want to revoke. If not given access for all objects in the mentioned schema is revoked.