Open pixelspark opened 6 years ago
Perhaps implement a more generic 'transfer ownership to [user]' mechanism (where [user] can be 'nobody').
Proposed syntax is LEAVE DATABASE x TO y;
to transfer, or LEAVE DATABABASE;
to disown it forever. TBD: Disowning forever is only allowed when there is at least one (valid?) entry in the grants table.
DISOWN DATABASE
removes the owner for a database, so that the only modifications that can be made to the database's contents are those allowed by the grants table. After being disowned a database cannot be removed anymore (perhaps allowDROP DATABASE
from a template so it can be made conditional?)