Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register

Change database user password


To change your database user password, execute the following SQL.

ALTER USER user_name PASSWORD 'any_password_here_in_single_quotes';

You may execute it using CSQL command line SQL Interpreter or CUBRID Manager.

CSQL Example

Before changing the password, make sure your database has been started.

~$ csql -u dba demodb
csql> ALTER USER dba PASSWORD 'my_new_pass';
Current transaction has been committed.
1 command(s) successfully processed.
csql>

Remember that in order to change a user password you need to be logged in as an admin user (or a user who has a permission to change a user password). In our case, dba is an admin user. Otherwise, you will get an error saying "UDPATE authorization failure".

Alternatively, you can set the database user password at the database creation time.

comments powered by Disqus
문서 정보
viewed 4191 times
번역 en
작성자
posted 2년 전
CUBRID
공헌자
마지막 수정시간 작년
변경 내역 보기
Share this article