I did
ALTER USER someuser WITH CREATEDB;
How could I revoke it please? I tried
revoke CREATEDB from crawler;
Got error role "createdb" does not exist
I am on postgresql 9.6.1
Just alter the user again and set the opposite option:
ALTER USER someuser WITH NOCREATEDB;
That should remove the permission to create databases from the user.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With