My Oracle Support Banner

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 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:
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


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

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