I was trying to reset the password.
r9mzsy20=# ALTER USER 9mz_dba WITH PASSWORD ‘92837474’;
ERROR: syntax error at or near “9”
LINE 1: ALTER USER 9mz_dba WITH PASSWORD ‘92837474..
For user – > u_9mz_rw and u_9mz_ro I was able to reset the password.
ALTER USER u_9mz_ro PASSWORD ‘92837474’ VALID UNTIL ‘infinity’;
ALTER USER u_9mz_rw PASSWORD ‘92837474’ VALID UNTIL ‘infinity’;
But for this USER 9mz_dba getting error.
Can anyone please help on it.
user is there only.
[1]: https://i.sstatic.net/fz45Eot6.png
New contributor
Hekro Meitei is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.