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:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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:
grant connect to kwilcox identified by newpassword;
Fails in 12c or above with:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
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