主页 / 问题 / 1201044
Accepted
Sova Kefirova
Asked:2021-11-07 00:56:34 +0000 UTC2021-11-07 00:56:34 +0000 UTC

无法使用 DBMS_CRYPTO 包

  • 772

我正在尝试使用函数DBMS_CRYPTO。从SYSTEM发射：

  DECLARE
        l_key      VARCHAR2 (2000) := '1234567890123456';
        l_in_val   VARCHAR2 (2000) := 'Confidential Data';
        l_mod      NUMBER
           :=   DBMS_CRYPTO.encrypt_aes128
              + DBMS_CRYPTO.chain_cbc
              + DBMS_CRYPTO.pad_pkcs5;
        l_enc      RAW (2000);
    BEGIN
       l_enc :=
          DBMS_CRYPTO.encrypt (utl_i18n.string_to_raw (l_in_val, 'AL32UTF8'),
                               l_mod,
                               utl_i18n.string_to_raw (l_key, 'AL32UTF8')
                              );
       DBMS_OUTPUT.put_line ('Encrypted=' || l_enc);
   END;

它给出：

Error report -
ORA-06550: Строка 5, столбец 17:
PLS-00201: идентификатор 'DBMS_CRYPTO' должен быть объявлен
ORA-06550: Строка 4, столбец 20:
PL/SQL: Item ignored
ORA-06550: Строка 11, столбец 11:
PLS-00201: идентификатор 'DBMS_CRYPTO' должен быть объявлен
ORA-06550: Строка 10, столбец 8:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.

我看它select * from dba_objects where object_name = 'DBMS_CRYPTO';给出了： 在此处输入图像描述

我尝试创建一个新用户并授予他权限：

grant execute on sys.dbms_crypto to VICE_SYS;

但也有错误：

Error starting at line : 1 in command -
grant execute on sys.dbms_crypto to VICE_SYS
Error report -
ORA-00942: таблица или представление пользователя не существует
00942. 00000 -  "table or view does not exist"
*Cause:

该怎么办？

oracle

1 个回答

  1. Best Answer

    您需要授予执行包的权限。这只能由用户完成SYS，其他人无法完成。

    DBMS_CRYPTO 安全模型
    Oracle 数据库将此包安装在 SYS 模式中。然后，您可以根据需要向现有用户和角色授予包访问权限。

    SQL> show user
USER is "ME"
SQL> exec dbms_output.put_line ('result='||dbms_crypto.randombytes (16));
ORA-06550: line 1, column 40:
PLS-00201: identifier 'DBMS_CRYPTO' must be declared

SQL> conn sys/pass@dbsrv/pdb1 as sysdba
Connected.
SQL> grant execute on dbms_crypto to me;

Grant succeeded.

SQL> conn me/me@mpsrv/pdb1.19c
Connected.
SQL> exec dbms_output.put_line ('result='||dbms_crypto.randombytes (16));
result=7311CFC8CF6AEB02C5B6238DFB8FBB1E

PL/SQL procedure successfully completed.
    • 3

相关问题