PL/SQL package to reset userpass words
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PL/SQL package to reset userpass words

  1. #1
    Join Date
    Aug 2014
    Posts
    2

    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!

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,479

    Cool

    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

  3. #3
    Join Date
    Aug 2014
    Posts
    2
    Quote Originally Posted by LKBrwn_DBA View Post
    Maybe this will help:

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

    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 !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width