Granted Privileges - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

Restrictions on users to read and write to Aster databases are managed as follows:

  • GRANT and REVOKE privileges that you set for a database object.
  • GRANT privileges on database objects to one or more roles or individual users.

You can grant membership in a role to another role or user, and thus grant the rights and privileges assigned to a role to its member roles and users.

Also, granted membership is a way to group users together who require access privileges to specific database objects. You can manage secure levels of access by granting specific privileges for the group as a whole. We recommend you create the group role first, and then add users to the role.