Search the Community

Hi, complete db administration newbie here. I created a postgres db "cprn_luetest", created user "cprn_admin", added user to db, synced grants, set this user/pass in app. App created a table "user" with owner "cprn_admin" but now I need to remove it so it could be recreated with updated schema. The problem is I cannot remove this table from phpPgAdmin because it logs me in as "cprn" and refuses to execute DROP saying: SQL error: ERROR: must be owner of relation user In statement: DROP TABLE "public"."user"In table level privileges I only see default grants: Role CREATE USAGE Grantor postgres Yes Yes postgres Yes Yes postgresIn public privileges I tried to add something useful but it didn't help: Role CREATE TEMPORARY CONNECT Grantor No Yes Yes cprn_luetest cprn_luetest Yes* Yes* Yes* cprn_luetest cprn_admin Yes Yes Yes cprn_luetest cprn Yes* Yes* Yes* cprn_luetestWhat do I need to add and how to get god-like powers and be able to destroy everything (literally) in my db from phpPgAdmin?