Updated on 2022-07-29 GMT+08:00

System Administrator

A system administrator is an account with the SYSADMIN permission. After a cluster is installed, a system administrator has the permissions of all object owners by default.

The user dbadmin created upon GaussDB(DWS) startup is a system administrator.

To create a database administrator, connect to the database as an administrator and run the CREATE USER or ALTER statement with SYSADMIN specified.

1
CREATE USER sysadmin WITH SYSADMIN password 'password';

Alternatively, you can run the following statement:

1
ALTER USER joe SYSADMIN;

To run the ALTER USER statement, the user must exist.