Privileges

When creating new schemas or users, the following privileges are required:

Note: When upgrading to NuoDB 4.0 from a previous release, existing users will have the CREATE SCHEMA privilege. All new users must be assigned the CREATE SCHEMA privilege by a DBA to enable them create new schemas. After upgrade to NuoDB 4.0, users must be assigned the CREATE USER privilege by a DBA to enable them create new users.

A privilege can be revoked from existing users by issuing the following command:

REVOKE CREATE ON SYSTEM.SCHEMAS FROM USER  [USER_NAME]