• grant alter on the schema to a role and then grant create table/view/proc to the role.

    Add users to the role.