xTuple.com xTupleU Blog & News Customer Support

How to change permission so I can delete records using pgAdminIII?

Hello all,

I am importing data and realized I made a bit of a mistake. I need to delete serveral hundred records in the crmacct table and all of the records in the custinfo table.  However, on these tables, pgAdmin reports that I do not have permissions to "maintain.... ".  How can I modify the setup so that I either permanently have permission or have permission now, and change it back again?


I am logged in as postgre user.


Thank you,


Found the answer right here


Need to remove the save password in pgAdmin, then login as admin....