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.

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 4143 times
번역 en
posted 2년 전
마지막 수정시간 작년
변경 내역 보기
Share this article