16.10 - Example: Granting Privileges on Sys_Calendar to All Users - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Sys_Calendar is a system database used to contain the Sys_Calendar.CalDates table and Sys_Calendar.Calendar view. The Calendar view is a user-accessible tool for date arithmetic. It permits easy specification of arithmetic expressions and aggregation, and is particularly useful when requesting values aggregated by weeks, months, year-to-date, years, and so on. You can use the Calendar view to get attributes for any date between the years 1900 and 2100, such as which day of the week or which week of the month a date occurs.

Use the following procedure to grant SELECT privilege on Sys_Calendar to all Teradata Database users.

  1. Start the client program of your choice and log on to Teradata Database as DBADMIN.
  2. Execute the following request:

    GRANT SELECT ON Sys_Calendar TO PUBLIC;