The privileges required are the same as those required for a conventional CREATE TABLE statement.
For the Copy Table syntax, if the CREATE TABLE statement specifies the NONTEMPORAL qualifier, the NONTEMPORAL privilege is also required on the target temporal table.