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

System Administrator

Updated at: Mar 13, 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 DWS created upon 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 USER 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