On this page, you will find the following information:
FACTS
- Folder Actions
- View Files
- RSS
Are you sure you want to remove this component?
Are you sure you want to remove this component?
Schoolbox requires access to the following tables, views and stored procedures to integrate correctly with FACTS.
SELECT access to:
- ALUMREL
- CALENDAR
- CODEMAST
- FAMILY
- IDENTITY
- STUDENT
- SUB
- SUBJECT
- SYSFILE
- TEACHER
- TIMEFILE
- TIMEPDHD
- TTABLE
- WORKAREA
EXEC access to:
- spSelTimetable
Are you sure you want to remove this component?
Are you sure you want to remove this component?
Example permission set script:
USE [pcschool] GO grant select on ALUMREL to schoolbox grant select on SUB to schoolbox grant select on SUBJECT to schoolbox grant select on STUDENT to schoolbox grant select on TIMEPDHD to schoolbox grant select on CALENDAR to schoolbox grant select on CODEMAST to schoolbox grant select on TEACHER to schoolbox grant select on FAMILY to schoolbox grant select on SYSFILE to schoolbox grant select on IDENTITY to schoolbox grant select on TTABLE to schoolbox grant select on WORKAREA to schoolbox grant exec on spSelTimetable to schoolbox grant select on TIMEFILE to schoolbox GO
Are you sure you want to remove this component?
Please create an SQL Authenticated MSSQL User for Schoolbox to access FACTS (not Windows Authenticated). The password must be 11 characters or less.
Example script:
USE [master] GO CREATE LOGIN [schoolbox] WITH PASSWORD='**REPLACE WITH STRONG PASSWORD**', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE [pcschool] GO CREATE USER [schoolbox] FOR LOGIN [schoolbox] GO