ORA-1031 When Executing 'Alter User' With DBMS_SQL
(Doc ID 1014103.102)
Last updated on JANUARY 17, 2020
Applies to:PL/SQL - Version 188.8.131.52 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!