New answers tagged

-1

ORA-28003: password verification for the specified password failed ORA-20001: Password length less than 16 If you are getting such a error, please follow the below. change the password with correct 16 character,will satisfy the password policy. change the profile from default to user defined profile/or create new profile alter user profile . now change ...


4

That's because you used the wrong format specifier. %I is for identifiers, but the password is a string literal, so you should use %L (and not include the single quotes). Compare these: SELECT format('PASSWORD %L', 'gut'), format('PASSWORD ''%I''', 'gut'); format | format ----------------+---------------- PASSWORD 'gut' | PASSWORD 'gut' (1 ...


Top 50 recent answers are included