Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-65317

cannot modify the user or role created by another application

Cause

An attempt was made to modify a user or a role that was created by another application. This can also happen when connected to an Application container and DBMS_PDB.SET_USER_EXPLICIT or DBMS_PDB.SET_ROLE_EXPLICIT procedure was invoked with the following type of users and roles:

  • Pluggable Database (PDB) Administrative user, that is, a user who has been granted PDB_DBA role inside the PDB.
  • The out-of-box Oracle supplied common users or roles.
  • Container Database (CDB) Common Users and roles, that is, users and roles created at CDB$ROOT container.

Action

Modify the user or role using the same application as the one that created the user or role. Do not try invoking SET_USER_EXPLICIT or SET_ROLE_EXPLICIT procedures in DBMS_PDB package against CDB common users or roles and PDB Administrative users.