What permissions are needed to drop a column from a table in postgres?

Started by Siddharth Jainabout 3 years ago2 messagesgeneral
Jump to latest
#1Siddharth Jain
siddhsql@gmail.com

Hi All,

What permissions does a user need to be able to drop columns from a table
in postgres? I did read this:
https://www.postgresql.org/docs/14/sql-grant.html
but could not find the answer.

Thanks

S.

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Siddharth Jain (#1)
Re: What permissions are needed to drop a column from a table in postgres?

On Sun, Apr 2, 2023 at 5:05 PM Siddharth Jain <siddhsql@gmail.com> wrote:

What permissions does a user need to be able to drop columns from a table
in postgres? I did read this:
https://www.postgresql.org/docs/14/sql-grant.html
but could not find the answer.

Because there are no permissions for that - you must either be the owner of
the table or be a superuser.

David J.