ORA-1031 When Executing 'Alter User' With DBMS_SQL
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 220.127.116.11 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2013***
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.
Error is: ORA-01031: insufficient privileges
PL/SQL procedure successfully completed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms