search

DASSL / ClassDB

An open-source system to let students experiment with relational data
https://dassl.github.io/ClassDB/
Other
7 stars 2 forks source link

removeClassDBFromServer.sql removes database-level items (E) #88

Closed smurthys closed 7 years ago

smurthys commented 7 years ago

removeClassDBFromServer.sql contains code that undoes aspects specific to the current database. Specifically, the statements to revoke CONNECT on database, the DROP OWNED BY statements, and the code to alter schema ownership should all be to removeClassDBFromDB.sql so they are executed in each DB where ClassDB is added.

wildtayne commented 7 years ago

Should be fixed in 023e9c6eaf73ceca6650099e40361e103829a528. I moved all of the ALTER SCHEMA, DROP OWNED BY, and REVOKE statements to removeClassDBFromDB. The only operations left in removeClassDBFromServer are the DROP ROLE statements.