Calling create_passthrough_verify_fcn returns an error

Question

Has anybody seen the following problem in calling create_passthrough_verify_fcn?  
  
We're trying to implement a custom password verify function by calling the following from the master user account:  
  
begin  
    rdsadmin.rdsadmin_password_verify.create_passthrough_verify_fcn(  
        p_verify_function_name => 'VERIFY_FUNCTION_SYS',   
        p_target_owner             => 'MASTER',  
        p_target_function_name => 'VERIFY_FUNCTION');  
end;  
  
VERIFY_FUNCTION is our custom password verify function and has been compiled successfully.  
  
The follow error is returned:  
  
ORA-20199: Error in rdsadmin_password_verify.create_passthrough_verify_fcn. ORA-20002: Unable to create the unprivileged user. Please contact AWS Support.  
ORA-06512: at "RDSADMIN.RDSADMIN_PASSWORD_VERIFY", line 70  
ORA-20002: Unable to create the unprivileged user. Please contact AWS Support.  
ORA-06512: at line 2  
  
Calling the simpler create_verify_function is OK but we need create_passthrough_verify_fcn to call our own custom function.

AWS-User-9938760 · Answer

Hi there,  
  
This can happen in situations where you have defined a restrictive password verification function on the "DEFAULT" profile and then run something that uses automation to create a new user in that profile. You might try setting the password verification function back to null for "DEFAULT", then retry creating the passthrough function, then re-enable password verification for "DEFAULT".   
  
Hope this helps. Thanks!  
Michael

snlau · Answer

After setting the default profile to null, it is now working.  
  
Thanks a lot.

Calling create_passthrough_verify_fcn returns an error

Add your answer

Relevant content