15.00 - Rules for Query_Database - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.