Skip to content

How to create a user (CREATE USER) and change a password (ALTER USER)#

Overview#

In addition to the system user SYS user, general users can be created using the create user statement, and after creating the user, the user's password can be changed using the alter user statement.

Applicable versions#

This document is written based on Altibase 6.3.1. If you need additional inquiries or updates, please leave a request post at http://support.altibase.com/en/ or make a comment on this page.

How to create a user and change a password#

-- Create
CREATE USER user_name IDENTIFIED BY password;
-- Change
ALTER USER user_name IDENTIFIED BY change_password;
-- Delete
DROP USER user_name;
DROP USER user_name CASCADE;

How to change SYS user#

The SYS user plays a special role as the database administrator.

Therefore, additional work is required when changing the password, please check through the following link:

How to change sys user password

Reference Manual#

ALTIBASE SQL User's Manual