DBMS_CLOUD_LINK_ADMIN Package
DBMS_CLOUD_LINK_ADMIN
package allows
the ADMIN user to enable a database user to register data sets or to access registered
data sets for a given Autonomous Database
instance, subject to the access restrictions as defined with the granted scope.
Privileges can also be disabled for a user that has the privileges set to register data sets or access registered data sets.
- DBMS_CLOUD_LINK_ADMIN Overview
Describes use of theDBMS_CLOUD_LINK_ADMIN
package. - Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
This table summarizes the subprograms included in theDBMS_CLOUD_LINK_ADMIN
package.
Parent topic: Autonomous Database Supplied Package Reference
DBMS_CLOUD_LINK_ADMIN Overview
Describes use of the DBMS_CLOUD_LINK_ADMIN
package.
Cloud Links provide a cloud-based method to remotely access read only
data on an Autonomous Database instance.
The DBMS_CLOUD_LINK_ADMIN
package
leverages Oracle Cloud
Infrastructure access mechanisms to make data sets accessible within a specific scope and in
addition there is a optional authorization step.
Parent topic: DBMS_CLOUD_LINK_ADMIN Package
Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
This table
summarizes the subprograms included in the DBMS_CLOUD_LINK_ADMIN
package.
Subprogram | Description |
---|---|
GRANT_AUTHORIZE Procedure |
Grants a user permission to invoke |
Allows a user to read registered data sets, subject to access restrictions imposed on data sets at registration. |
|
Allows a user to register a data set for remote access. |
|
Revokes a user's permission to invoke |
|
Disallows a user from accessing registered data sets of the Autonomous Database instance. |
|
Disallows a user from registering data sets for remote access. Data sets that were already registered by the user are unaffected. |
- GRANT_AUTHORIZE Procedure
The procedure grants a user permission to invoke theDBMS_CLOUD_LINK.GRANT_AUTHORIZATION
andDBMS_CLOUD_LINK.REVOKE_AUTHORIZATION
procedures. - GRANT_READ Procedure
The procedure allows a user to read registered data sets, subject to the access restrictions imposed on data sets when a data set is registered usingDBMS_CLOUD_LINK_ADMIN.GRANT_REGISTER
. - GRANT_REGISTER Procedure
The procedure allows a user to register a data set for remote access. - REVOKE_AUTHORIZE Procedure
This procedure disallows a user from invokingDBMS_CLOUD_LINK.GRANT_AUTHORIZATION
andDBMS_CLOUD_LINK.REVOKE_AUTHORIZATION
procedures. - REVOKE_READ Procedure
This procedure disallows a user from accessing registered data sets on the Autonomous Database instance. - REVOKE_REGISTER Procedure
The procedure disallows a user from registering data sets for remote access. Data sets that were already registered by the user are unaffected.
Parent topic: DBMS_CLOUD_LINK_ADMIN Package
GRANT_AUTHORIZE Procedure
DBMS_CLOUD_LINK.GRANT_AUTHORIZATION
and DBMS_CLOUD_LINK.REVOKE_AUTHORIZATION
procedures.
Syntax
DBMS_CLOUD_LINK_ADMIN.GRANT_AUTHORIZE
(
username IN VARCHAR2
);
Parameters
Parameter | Description |
---|---|
|
Specifies a username. |
Usage Notes
-
To enable authorization for a data set with
DBMS_CLOUD_LINK.GRANT_AUTHORIZATION
, you have to have granted the privilege withDBMS_CLOUD_LINK_ADMIN.GRANT_AUTHORIZE
. This is true for ADMIN user as well; however ADMIN user can grant this privilege to themself.
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
GRANT_READ Procedure
DBMS_CLOUD_LINK_ADMIN.GRANT_REGISTER
.
Syntax
DBMS_CLOUD_LINK_ADMIN.GRANT_READ
(
username IN VARCHAR2
);
Parameters
Parameter | Description |
---|---|
|
Specifies a username. |
Usage Notes
-
To read data sets, you have to have granted the privilege with
DBMS_CLOUD_LINK_ADMIN.GRANT_READ
. This is true for ADMIN user as well; however ADMIN user can grant this privilege to themself. -
A user can query
SYS_CONTEXT('USERENV', 'CLOUD_LINK_READ_ENABLED')
to check if they are enabled forREAD
access to a data set.For example, the following query:
SELECT SYS_CONTEXT('USERENV', 'CLOUD_LINK_READ_ENABLED') FROM DUAL;
Returns '
YES
' or 'NO'
.
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
GRANT_REGISTER Procedure
Syntax
DBMS_CLOUD_LINK_ADMIN.GRANT_REGISTER
(
username IN VARCHAR2,
scope IN CLOB
);
Parameters
Parameter | Description |
---|---|
|
Specifies a user name. |
|
Specifies the scope in which permissions to publish are to be granted to the specified user. Valid values are:
|
Usage Notes
-
To register data sets, you have to have granted the privilege with
DBMS_CLOUD_LINK_ADMIN.GRANT_REGISTER
. This is true for ADMIN user as well; however ADMIN user can grant this privilege to themself. -
A user can query
SYS_CONTEXT('USERENV', 'CLOUD_LINK_REGISTER_ENABLED')
to check if they are enabled for registering data sets.For example, the following query:
SELECT SYS_CONTEXT('USERENV', 'CLOUD_LINK_REGISTER_ENABLED') FROM DUAL;
Returns '
YES
' or 'NO'
.
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
REVOKE_AUTHORIZE Procedure
DBMS_CLOUD_LINK.GRANT_AUTHORIZATION
and DBMS_CLOUD_LINK.REVOKE_AUTHORIZATION
procedures.
Syntax
DBMS_CLOUD_LINK_ADMIN.REVOKE_AUTHORIZE
(
username IN VARCHAR2
);
Parameters
Parameter | Description |
---|---|
|
Specifies a username. |
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
REVOKE_READ Procedure
Syntax
DBMS_CLOUD_LINK_ADMIN.REVOKE_READ
(
username IN VARCHAR2
);
Parameters
Parameter | Description |
---|---|
|
Specifies a username. |
Usage Note
-
A user can query
SYS_CONTEXT('USERENV', 'CLOUD_LINK_READ_ENABLED')
to check if they are enabled forREAD
access to a data set.For example, the following query:
SELECT SYS_CONTEXT('USERENV', 'CLOUD_LINK_READ_ENABLED') FROM DUAL;
Returns '
YES
' or 'NO'
.
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms
REVOKE_REGISTER Procedure
Syntax
DBMS_CLOUD_LINK_ADMIN.REVOKE_REGISTER
(
username IN VARCHAR2
);
Parameters
Parameter | Description |
---|---|
|
Specifies a user name. |
Usage Note
-
A user can query
SYS_CONTEXT('USERENV', 'CLOUD_LINK_REGISTER_ENABLED')
to check if they are enabled for registering data sets.For example, the following query:
SELECT SYS_CONTEXT('USERENV', 'CLOUD_LINK_REGISTER_ENABLED') FROM DUAL;
Returns '
YES
' or 'NO'
.
Parent topic: Summary of DBMS_CLOUD_LINK_ADMIN Subprograms