12 May 2018        Add to Favorites   Report

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


Syntax:

GIVE database_name TO user_name;


Example:

GIVE Marketing TO Ben;

Read great educational content like this and a lot more ! Create my free account now 🎁

Copied