ORA-1031 When Executing 'Alter User' With DBMS_SQL (Doc ID 1014103.102)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2013***

Symptoms

 The following error is generated when end users who have privilege to execute on a stored function attempt to execute a stored function owned by another user:

    ORA-01031: insufficient privileges

This error does not occur when the stored function is executed by the owner, or when executed by the user when the function is owned and compiled under the user's schema before execution.

The stored function is using DBMS_SQL to execute and 'alter user' statement.

 
Fails with:

Error is: ORA-01031: insufficient privileges
FALSE

PL/SQL procedure successfully completed.

Cause

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 hundreds of Community platforms