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 18Enjoy 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
Post Comment