I am trying to create a user with permission to create tables in a given schema. ========= create role my_owner; create schema mine authorization my_owner; create user hist with password 'my1' name 'historical data' schema "mine"; grant my_owner to hist; ========= I have tried : GRANT ALL on mine to hist; and GRANT ALL on mine to my_owner; and GRANT create table on mine to my_owner; and GRANT create table on mine to hist; all with no success.