Grant only Usage on classdb schema to instructors and DB managers

DASSL / ClassDB

An open-source system to let students experiment with relational data

https://dassl.github.io/ClassDB/

Other

8 stars 2 forks source link

Grant only Usage on classdb schema to instructors and DB managers #160

Closed afig closed 6 years ago

afig commented 6 years ago

This PR changes the privileges on the classdb schema so that instructor and DB managers only have the USAGE privilege. Previously, they were incorrectly given ALL PRIVILEGES.

So far in my preliminary testing, this does not seem to impact the functionality of any part of the system. However, I still need to test a bit more since this is a relatively significant change.

Fixes #148