Oracle | DBMS_USER

Oracle DBMS_USER_CERTS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Utility enabling the addition, deletion and maintenance of certificates in the database.

This package uses subprograms to add and delete X.509 certificates which are used for blockchain table signature verification by the current user.

A typical use case is to attach a digital signature to a row in a blockchain table and be able to verify the digital signature later. A certificate used to sign one or more rows in blockchain tables and which has since expired should remain in the database until all those rows have been deleted from the blockchain tables.

AUTHID CURRENT_USER

Dependencies

DBMS_USER_CERTS_LIB

Documented Yes

Exceptions

Error Code	Reason
ORA-TBD

First Available 20c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/TBD

Subprograms

ADD_CERTIFICATE

DROP_CERTIFICATE

ADD_CERTIFICATE (new 20c)

Adds X.509 certificates which are used for signature verification of blockchain tables dbms_user_certs.add_certificate( x509_cert IN BLOB, cert_guid OUT RAW);

TBD

DROP_CERTIFICATE (new 20c)

Drops a certificate that is used for signature verification of blockchain tables dbms_user_certs.drop_certificate(cert_guid IN RAW);

TBD