How to create a database administrator user (DBA user)?

Help Security
1

As I know root is the default administrator user who has full access on Memsql Cluster. Please let me know how to add a database administrator user (DBA user) and which grants need to provide to him. It would be helpful if you share the steps.

2

The docs describe CREATE USER and GRANT An example:

CREATE USER joe;
GRANT SELECT ON mydb.* TO 'joe'@'%';

Which grants would you need to give a DBA user? This likely depends on the requirements of your business and the needs of their tasks. SingleStoreDB Cloud ยท SingleStore Documentation has a full list of the permissions you can grant.