Search the Community

Hi. I'm trying to figure out how functions and procedures works into MariaDB. And i creared a sinple function: BEGIN declare ans TEXT; select answer into ans from text_answers ORDER by rand() limit 1; RETURN ans; END and wanted to call this function by: SELECT * from dbo.random_text_answer but i've got a error of loss privileges... i wanted to try to check "Adjust privileges" in edit window, but this checkbox is unactive.. What should I do in this case?

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?