Privileges
When creating new schemas or users, the following privileges are required:
-
The
CREATE SCHEMA
privilege is required on the SCHEMAS table. For more information on using this table, see SCHEMAS System Table Description. -
The
CREATE USER
privilege is required on the USERS table. For more information on using this table, see USERS System Table Description.
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 to 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]