Help Center > > Developer Guide> Database Security Management> Managing Users and Their Permissions> System Administrator

System Administrator

Updated at: Dec 30, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel