Grant with user name and table name
GRANT SELECT ON Student.ClassEnrollment TO Susan WITH GRANT OPTION;