Give - Transfer ownership of a database in Teradata
Transfers ownership of a database or user space to another user. Also transfers all databases and users owned by the transferred database or user.
- You must have the DROP DATABASE privilege on the given object
- You must have the CREATE DATABASE privilege on the recipient
GIVE database_name TO user_name;
GIVE Marketing TO Ben;