Add DISOWN DATABASE support

Open pixelspark opened this issue 8 years ago • 2 comments

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 allow DROP DATABASE from a template so it can be made conditional?)

Dec 04 '17 20:12 pixelspark

Perhaps implement a more generic 'transfer ownership to [user]' mechanism (where [user] can be 'nobody').

Dec 04 '17 20:12 pixelspark

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.

Dec 10 '17 09:12 pixelspark