My Oracle Support Banner

Encrypting credentials data dictionary like link$ and scheduler$_credentials in 19c as sys user fails with ORA-28447: insufficient privilege to execute ALTER DATABASE DICTIONARY statement (Doc ID 2625473.1)

Last updated on MARCH 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 #### encrypting the credentials data dictionary like link$ and scheduler$_credentials in 19c ########

SQL>
SQL> connect /as sysdba
Connected.
SQL>
SQL>
SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL>
SQL> show user;
USER is "SYS"
SQL>
SQL>
SQL> alter database dictionary encrypt credentials;
alter database dictionary encrypt credentials
*
ERROR at line 1:
ORA-28447: insufficient privilege to execute ALTER DATABASE DICTIONARY
statement

Changes

 Trying to encrypt credential data dictionary in 19c database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.