I was setting up Noddy on my local machine and ran into a select permissions on ScormObjectHierarchy. This leads me to the
question of what database rights are needed for the user we set up for access?
Will the sql user need more than Select, and Exec on the procs?
Yes, the selected user will need select, insert, update and delete permissions on all SCORM tables. We use generated inline
sql (watching out for sql injection attacks) in many places to work with multiple database engines with the same base code.