Oracle | DBMS_USER

Oracle DBMS_USER_CERTS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

First Available 20c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmscert.sql
{ORACLE_HOME}/rdbms/admin/prvtcert.plb

Subprograms

ADD_CERTIFICATE	ADD_COPY	DROP_CERTIFICATE_REPL
ADD_CERTIFICAT_REPL	DROP_CERTIFICATE

ADD_CERTIFICATE (parameter renamed in 23ai)

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

TBD

ADD_CERTIFICATE_REPL (new 23ai)

Undocumented dbms_user_certs.add_certificate_repl( x509_cert IN BLOB, cert_id IN RAW, cert_guid IN VARCHAR2, username IN VARCHAR2);

TBD

ADD_COPY (new 23ai)

Undocumented dbms_user_certs.add_copy( x509_cert IN BLOB, cert_id IN RAW, username IN VARCHAR2 DEFAULT NULL);

TBD

DROP_CERTIFICATE (parameter renamed in 23ai)

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

TBD

DROP_CERTIFICATE_REPL (new 23ai)

Undocumented dbms_user_certs.drop_certificate( cert_id IN RAW, username IN VARCHAR2);

TBD