Error: The SELECT permission was denied on the object 'tf_EA7FindCoursesForOnlineRequests

When editing course requests in NetClassroom, we select to add an alternate request and click the binoculars to find a course. Upon selecting search, we encounter the error: The SELECT permission was denied on the object 'tf_EA7FindCoursesForOnlineRequests.

This particular error is tied to SQL permissions. Follow these steps to apply the right permissions to your SQL server:

1. On the SQL server, open SQL Management Studio.
2. Go to Databases
3. Select database for The Education Edge.
4. Expand the database section and then expand the Security section.
5. Expand users and right click on NETCLASSROOM_USER.
6. Select Properties.
7. Check the box for db_datareader under Roles.
8. Click OK.

Steps to Duplicate

1. Log into NetClassroom as a  student
2. Go to requests > edit requests > under additional requests at the bottom, select New
3. Select the binoculars to search for a new class.
4. Select Search
5. Receive Error: The SELECT permission was denied on the object 'tf_EA7FindCoursesForOnlineRequests.

Was this article helpful?