Help Center> Data Warehouse Service> Developer Guide> Database Security Management> Managing Users and Their Permissions> System Administrator
View PDF

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 GaussDB(DWS) 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 "Bigdata@123";

Alternatively, you can run the following statement:

1
 
ALTER USER joe SYSADMIN;

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