 
 
 /*
-Finally, lock all permissions down to minimum.
+Lock all permissions down to minimum.
 
 NOTE: Do this as user 'postgres' in the userdata table!
 


This single table allows us to rebuild the complete, publicly visible
database.
*/
CREATE TABLE users.collectionHistory (


/*Make sure all permissions are OFF by default*/
REVOKE all privileges ON SCHEMA PUBLIC FROM usermanager;
REVOKE all ON DATABASE POSTGRES FROM usermanager;
REVOKE all ON DATABASE userdata FROM usermanager;
REVOKE create ON DATABASE userdata FROM usermanager;

/*Need to use to do anything else*/
GRANT connect ON DATABASE userdata TO usermanager;
GRANT usage ON SCHEMA PUBLIC TO usermanager;
GRANT usage ON SCHEMA users TO usermanager;

