Permissions problems with cPanel and phpPgAdmin/postgresql
I've created a PostgreSQL database using cPanel. Everything seems to work fine - I can access the database from PHP, add and delete records, drop tables, and so forth. However, if I try and manipulate the data with phpPgAdmin, I get various problems. If I log in to PgAdmin as "myusername" (the cpanel default), I can browse all my databases, but if I try and open a table I get the error "ERROR: mytable: permission denied". If I log in as "myusername_mydatabase" I can't see any databases in the listing.
What am I doing wrong? All I wanted to do was take a look at some data in a DB and watch it change as my PHP script edits it.
Thanks,
Phil.
