pandaZW pandaZW - 10 months ago 54
Linux Question

Postgres doesn't ignore upper and lower letters

My unix user is

. And I found I have no privilege. So,I use
and found a role named

After I dropped it, I found this secret.

postgres=# ALTER role Ru with superuser;
ERROR: role "ru" does not exist

How can I do with this?

I know this is a

  • -

Answer Source

This should work!

ALTER ROLE 'Ru' WITH SUPERUSER; --whatever privilege you want to give