Database Access and Security

To access a NuoDB database, you must have a valid NuoDB database username and password. A NuoDB database user is independent of the database superuser (often referred to as the DBA User). It is also not the same as a NuoDB domain administrator.

  • A NuoDB domain administrator has the ability to use nuocmd to manage a NuoDB domain, for example to create and manage databases and their resources.

    • These users have no access to the contents of any database.

    • You can create new domain users and control what they are permitted to do.

    • Refer to User Authentication and Authorization for details.

  • The database superuser is the user created at the same time as the database. They have total privileges over the database and can run any valid SQL command.

  • Database users have access to the contents of a database.

    • Roles and privileges control what access users are allowed.

    • The database superuser is just one such user that happens to have full access.

Domain users (nuocmd users) and database users are totally independent of each other, even if they happen to have the same username.