DBMS_DATA_ACCESS_ADMIN Package

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

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 grants a consumer user the privilege to create federated tables over a specified remote provider schema or schema object.
REVOKE_READ	This procedure revokes a consumer user privilege to create federated tables over a specified remote provider schema or schema object.

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.