Open topic with navigation
When creating new schemas or users, the following privileges are required:
CREATE SCHEMAprivilege is required on the SCHEMAS table. For more information on using this table, see SCHEMAS System Table Description.
CREATE USERprivilege is required on the USERS table. For more information on using this table, see USERS System Table Description.
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]