-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|