Change Of Functionality Between 11g And 12c And Above With Grant Connect Using Identified By Clause (Doc ID 2694560.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Packaged application is currently using an 11g database and planning to upgrade to 19c. Change password functionality in the application issues a statement like this "grant connect to username identified by newpassword" as the currently connect user to change the password. This works in 11g but fails in 12c with "ORA-01749: you may not GRANT/REVOKE privileges to/from yourself".

Need to know if this functionality change is documented somewhere and if it's possible to get the 11g behavior in a supported version (preferably 19c).

Ex: works in 11g:
connect kwilcox/oldpassword
grant connect to kwilcox identified by newpassword;

Fails in 12c or above with:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

Cause

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