12 May 18 ·  nVector in teradata ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

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;

nVector

posted on 12 May 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds