The user would need to be granted: create any table priv. This will allow the user to create tables in ANY schema in the db. To create the table, the user will have to specify the username under whose schema it would be created, else the table will get created in the users' schema itself. For example, if the developer need to create table in CFF schema, he would issue the DDL in this way:
-
create table CFF.table_name
(col1 datatype,
clo2 datatype ...);