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 SEPTEMBER 08, 2020

Applies to:

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

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

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