Yes, faculty retain borrowing privileges and can access databases and e-books remotely after retirement. The borrowing loan periods and policies are the same for current and retired faculty.
Per SMU HR, you are considered an SMU retiree if you leave SMU at age 60+ with at least 10 years of SMU employment and were enrolled in the SMU Medical Plan during the 5-year period immediately preceding your retirement date.