My Oracle Support Banner

Grant Role Via Procedure Fails When Connected As Proxy User (Doc ID 2315613.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

A grant role in a stored procedure fails when the owner of the procedure is connected as a proxy user. When the owner is connected via own credentials, the call succeeds. This fails only on 12.2.0.1, but not on 12.1.0.2 or 11.2.0.4.

Changes

 

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!


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