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!