As an administrator I would like to be able to separate CREATE TABLE and DROP TABLE privileges. Ideally I would like only the owner/creator of a table to be able to drop that table. At the moment if a user has CREATE privileges on a schema they can drop any table in that schema, which risks accidental data loss if a user can drop another user's table.
As an administrator I would like to be able to separate CREATE TABLE and DROP TABLE privileges. Ideally I would like only the owner/creator of a table to be able to drop that table. At the moment if a user has CREATE privileges on a schema they can drop any table in that schema, which risks accidental data loss if a user can drop another user's table.