I am currently sync my Azure users with Moodle for Single Sign-On. I need to clean up my student user Azure DB, how will Moodle respond to removing these student accounts ? In particular will the grades be lost ?
Old Student Accounts
Number of replies: 6Re: Old Student Accounts
In moodle (mdl_user table) each row is unique and has an ID column - which is sequential. The ID column in that table, for all things moodle DB, is a student. IF row 56 is for Humphry Snerd ... everything belonging to Humphry is that ID number.
When moodle user accounts expire, the row stays ... new accounts simply use the highest ID number available. Moodle does not go back, find ID numbers that are not used to populate info for a user.
That help explain?
'SoS', Ken
Re: Old Student Accounts
You have a choice in your authentication settings what to do with accounts that are removed in the remote server - they can be suspended or deleted. However, the database, as Ken alluded to, still keeps the old data so it would be possible to undelete a user account and restore enrollments to get grades back. Or if you only suspend those accounts, that data will be accessible still.
Re: Old Student Accounts
Hello Emma and Ken - Great replies - thanks very much.
What I would prefer to do is suspend the student account in Moodle when the account is removed from Azure. ( This way I do not lose any of the grades, great for archival purpose)
Emma - where would I find that option to suspend or delete ?
What I would prefer to do is suspend the student account in Moodle when the account is removed from Azure. ( This way I do not lose any of the grades, great for archival purpose)
Emma - where would I find that option to suspend or delete ?
Re: Old Student Accounts
'archival' ... caution ... how many years do you anticipate or imagine? What is your entities legal obligation to retain records? Those are questions for consideration, not response.
Again ... encourage you to actually look at the data present in mdl_user table.
'SoS', Ken
Again ... encourage you to actually look at the data present in mdl_user table.
'SoS', Ken
Re: Old Student Accounts
In your authentication settings - I am presuming you are using ldap?
Re: Old Student Accounts
I'm using Office O365 integration, yes i found the setting in there.
Appreciate your response.
Appreciate your response.