Open topic with navigation
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.
In addition to this
ADMINISTRATOR role, this 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.
All other users of the system can create users, 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.