Hi

Sorry for the delay in reply.

U will have to create a separate login for each student. Then in the students respective database u can create the database user corresponding to the students login.