Any database user can create a schema; however, the user must have permission to create the objects that pertain to the schema (for example, CREATE PROCEDURE, CREATE TABLE, and so on).
Note that creating a schema does not implicitly make that new schema the current/default schema. You must explicitly set that schema with the SET SCHEMA statement if you want the new schema to become the current schema.
The following example creates a schema named FINANCE and assumes the user id is SMITH:
CREATE SCHEMA FINANCE; CREATE TABLE EMPLOYEE (EMP_ID INTEGER); -- NOTE: The employee table is qualified to SMITH.EMPLOYEE, not -- FINANCE.EMPLOYEE. Creating a schema does not implicitly make -- that new schema the current/default schema. SET SCHEMA FINANCE; CREATE TABLE EMPLOYEE (ID INTEGER); SELECT ID FROM EMPLOYEE; -- In this case, the table is qualified to FINANCE.EMPLOYEE