About NuoDB DBAs
When you create a NuoDB database, you specify a database administrator username and password (see Creating Databases).
This database administrator user is the superuser of the database and is, by default, granted the ADMINISTRATOR
role.
This ADMINISTRATOR
role gives this user the privilege to modify system property values using the SET
command (see SET).
Only users that have been granted the ADMINISTRATOR
role can modify the system property values.
Users that have been granted the ADMINISTRATOR
role can also create functions and stored procedures.
If the DBA password is lost and there is no other user with ADMINISTRATOR role privileges, or the ability to change the DBA user’s password, contact NuoDB Support for a utility to regain DBA access to the database.
|
Alternatively, give specific privileges to another user to be able to execute ALTER USER commands on the DBA user. For example: |
GRANT ALTER ON USER <dba user> to <another user>
In addition to the ADMINISTRATOR
role, the database administrator user that is created when creating a database is also, by default, granted the DBA
role.
The DBA
role gives users the privilege to create functions and stored procedures, but not modify system property values.
Users granted the SYSTEM.ADMINISTRATOR role can create and drop users. Other users of the system can create roles, select from, but not update, system tables, create database objects and grant privileges on those database objects to other users.
Other users cannot create functions and stored procedures without having the DBA
role granted to them.
NuoDB recommends that users with the ADMINISTRATOR
role not be used as an application user.