Giving One User to Another | VantageCloud Lake - Giving One User to Another - Teradata VantageCloud Lake

When you give one object to another, all its space goes with it. If you drop the object, the space goes to the immediate owner. When you give databases or users, all descendants of the object remain descendants of the object. When you give the object to new parents, the ownership of the space is transferred, but the limits remain the same.

Adjusting Perm Space Limits Using SQL

Perm space limits are easy to adjust, for example:

CREATE DATABASE Temp FROM HR AS PERM = 2000000;
GIVE Temp TO Finance;
DROP DATABASE Temp;