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)"
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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 !!!
Originally Posted by LKBrwn_DBA
2) Done - all is working very well.
Many thanks !
Click Here to Expand Forum to Full Width