Re: REVOKE DROP rights

2019-09-11 Thread Miles Elam
Makes sense. Thanks! On Wed, Sep 11, 2019 at 1:43 PM Tom Lane wrote: > Miles Elam writes: > > Is there any way to prevent a user from dropping a table when that user > has > > create rights? I'd like to allow that user to be able to create and > delete > > their own tables but not specific shar

Re: REVOKE DROP rights

2019-09-11 Thread Tom Lane
Miles Elam writes: > Is there any way to prevent a user from dropping a table when that user has > create rights? I'd like to allow that user to be able to create and delete > their own tables but not specific shared tables. I think maybe you didn't read the manual closely. Creation privileges c

REVOKE DROP rights

2019-09-11 Thread Miles Elam
Is there any way to prevent a user from dropping a table when that user has create rights? I'd like to allow that user to be able to create and delete their own tables but not specific shared tables. Is the only way to put the shared tables into a different schema? Thanks in advance