GLOP | Privileges Needed for DB Administration | Teradata Vantage - GLOP - Teradata Vantage - Analytics Database

SQL Data Control Language

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
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢
Goal Privilege User Needs
Create GLOP set CREATE GLOP privilege on containing database or user.
Drop GLOP set DROP GLOP privilege on database or user containing GLOP_set_name.
DROP GLOP privilege is automatically granted to creator and owner of GLOP set.
Allow user or database to specify access to GLOP set from database other than that which contains external routine referencing GLOP set GLOP MEMBER privilege

If GLOP is in same database as external routine, access to GLOP is automatically granted.

Database where external routine resides must have CREATE GLOP, DROP GLOP, or GLOP MEMBER privileges on GLOP set