Closed wildtayne closed 6 years ago
I just pushed a much improved version of the views.
LastDDLOperation
from relevant views for testing purposes, since it is missing elsewhere in the DB (see here). I can re-add this if we want it back.Also, strictly speaking, this PR should be blocked until the DDL/Connection activity attributes are implemented in ClassDB.User/Instructor/Student/DBManager
.
Closing until dir reorg is done
Reopened now that the directory reorg is done. Views are now added in src/db/reco/addFreqeuntViewsReco.sql
.
BTW - Doing a clean install of ClassDB is now very streamlined with the new directory structure 👍
This PR adds the frequent user views discussed in #134. Again, I am creating this PR so this code can be reviewed prior to integration with the new user role system.
SELECTS
a view in the public schema, which executes aSECURITY DEFINER
function in the public schema, which executes a function in theClassDB
schema. This allows students to access otherwise privileged data through a view.Fixes #134