PL/SQL package to reset userpass words

I have a need for a pl /sql package to provide to users to reset Oracle passwords and create users. The package owner has DBA privs and grants execute to Users. The User has the following privs: create session, alter user,create user.
My research has indicated these are the required privs- but it does not work. When the User executes the package - the following error occurs: "insufficient privileges". Yet- the user is successful when directly executing alter user or create user from sqlplus. Any suggestions, recommendations are Welcomed! I cannot provide DBA role to the User- hence, the pl/sql package. Thanks!

Maybe this will help:

1) Package must be created with "AUTHID DEFINER"
2) Grant execute on the package to the "users(s)"

:rolleyes:

Quote:

---

Originally Posted by LKBrwn_DBA

Maybe this will help:

1) Package must be created with "AUTHID DEFINER"
2) Grant execute on the package to the "users(s)"

:rolleyes:

---

1) You reminded me exactly what needed to be done ! AUTHID DEFINER (Definer Rights) is the default setting. In this case - I need AUTHID Current_User (Invoker Rights). The invoker has the designated privs to execute. I've re-compiled the package with AUTHID Current_User , and it works like a Charm ! Thanks !!!
2) Done - all is working very well.
Many thanks !