Privileges

Users assigned the ADMINISTRATOR role, the DBA role, or the creator of the schema have the privilege to create new database objects in the schema or drop the schema.

The CREATE SCHEMA privilege on the SCHEMAS table allows the user to create new schemas and the CREATE USER privilege on the USERS table allows the user to create a new user. Only a user granted the DBA role can give these privileges to other users using the GRANT statement.

To revoke existing privileges from a user, use the REVOKE statement.