FACTS

Overview - FACTS

Are you sure you want to remove this component?

Requirements

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

Schoolbox & FACTS

Are you sure you want to remove this component?

Set MSSQL Permissions

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

MSSQL User Creation Script

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