Example: Granting Privileges on Sys_Calendar to All Users
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 Teradata SQL Assistant and log on as DBADMIN.
2 Enter the following statement in the main query window:
GRANT SELECT ON Sys_Calendar TO PUBLIC
3 Click the Execute button to run the query.
4 Close Teradata SQL Assistant.
Reference Information
|
For Step... |
Information on... |
Is available in... |
|
All |
Sys_Calendar and the Calendar view |
Data Dictionary |