The only system privilege you need is the ALTER USER system privilege. But even if you sign on as SYSTEM, which has the DBA role that contains the ALTER USER system privilege, you won't be able to execute this procedure. That is because the procedure is owned by SYS and SYS has not granted EXECUTE object privileges on this package to anyone. So you'll either have to sign on as SYS to run this procedure or grant EXECUTE on this to the user you want to run this procedure.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.