To create databases, tables, and other database objects, as well as to execute certain commands and stored procedures, you must have the appropriate permissions. See the Reference Manual: Commands and Chapter 17, “Managing User Permissions,” in the System Administration Guide: Volume 1.