Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle 12c modify account password (with special characters)

Shulou Source: shulou.com Published: 2022-06-01 22:40:34 11月07日 Update

When changing the account password in oracle 12c with special characters, oracle will prompt: enter value for xxx by default.

However, when you re-enter it, you will find that the reset password is different from your request, and the special characters are ignored and filtered out.

Treatment method:

Set define off

Alter user xxxx identified by xxxx

Tags: Special character password account number situation method time processing prompt input Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Apple Shulou Technology NVidia Redmi Shulou Tech Info