Granting Privileges to a User - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageā„¢
  1. From the client program of your choice, log on to Vantage as DBADMIN.
  2. Run a GRANT request similar to the following:
    GRANT privilege 
    ON database_object_name 
    TO username;
    privilege
    Privilege to grant to the user.
    database_object_name
    Database object on which to grant privilege to user.
    Based on the values of the Database Name, Object Type, and Objects fields.
    username
    User to whom to grant privilege on database object.
    Based on the user selected from the To/From User tab.