Giving Ownership - Teradata Vantage - Analytics Database

Security Administration

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-29
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantageā„¢

You can use the GIVE statement to transfer ownership of a database or user to a new owner, who may or may not be part of the current parent-child hierarchy. The GIVE statement transfers to the recipient the specified database or user space, and all of the databases, users, and objects owned by that database or user.