16.20 - Non-User Privileges - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

In some cases, you might need to assign privileges to a non-user object, for example:

  • You can grant privileges to a role based on the database access requirements of a specific group of users, and then grant role membership to each of the users individually.
  • If you set up a separate Views database, you must grant the database privileges on the underlying tables of the views contained within that database.