Database Privilege Types - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

All database privileges are either explicit or implicit.

Privilege Description
Implicit Privileges
Ownership Teradata Vantage™ grants implicit privileges on a database object to the owner of the space that contains the object.

See Ownership Privileges.

Explicit Privileges
Automatic When a user creates a database object, Analytics Database automatically grants privileges to:
  • The creator of the object
  • A newly created user or database

See Automatic Privileges.

GRANT You can GRANT privileges:
  • Directly to a user or database
  • To a role, then GRANT membership in the role to one or more users
  • To an external role, then map the role to one or more groups of directory users

See Working with User Privileges in Teradata Vantage.

Inherited Privileges that a user acquires indirectly:
Assigned Security constraints define user access to table rows protected by a corresponding security constraint column.
You can assign the security constraints in a CONSTRAINT object to a:
  • User, by specifying the CONSTRAINT object in a:
    • CREATE USER or MODIFY USER statement
    • CREATE PROFILE or MODIFY PROFILE statement, and then assigning the profile to the user
    See Assigning Security Constraints.
    Constraint OVERRIDE privileges, which allow a user to bypass row level security protection, are granted using the GRANT OVERRIDE CONSTRAINT statement.

    See Granting SQL DML OVERRIDE Privileges.

  • Table, by defining a constraint column that is named for the CONSTRAINT object in a CREATE TABLE or ALTER TABLE statement.

    See Working with Security Constraint Columns.