I have a procedure owned and hosted by a user that has unlimited tablespace privilege.
however when performing alter table partition move operations to move and compress partitions (basic) into newly created tablespaces some of these
partitions results in ORA-01950 depending on who the owner of the partition is.
Looking closely I can see consistently where it's failing the owner of that partition don't have both CONNECT/RESOURCE roles.