Sys_Calendar is a system database used to contain the Sys_Calendar.CalDates table and Sys_Calendar.Calendar view. The Calendar view, a user-accessible tool for date arithmetic, 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 Vantage users.
- Start the client program of your choice and log on to Vantage as DBADMIN.
- Run the following request:
GRANT SELECT ON Sys_Calendar TO PUBLIC;
See also System Calendar View.