Rules for Query_Database - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Rules for Query_Database

Note that Query_Database objects are organized in such a way that the entire database can be archived in one operation. You can also archive Upsert_Database in the same operation if you choose to do so.

The following rules apply to Query_Database.

  • Both Query_Profile and Upsert_Profile users can perform the following functions against Query_Database.
  • CALL permitted stored procedures
  • EXECUTE permitted macros
  • SELECT rows from Tables_Database objects through views
  • The database contains only views, stored procedure definitions, and macros that permit an end user to query or grant privileges on Tables_Database objects indirectly.