Ways to edit users and permissions for database

From: Alexander Reichstadt <lxr(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Ways to edit users and permissions for database
Date: 2012-03-14 07:38:57
Message-ID: BC6EA4E0-61C5-454D-AC16-09535E5770BF@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

this was probably asked dozens of times before, but I couldn't find where, and neither in the docs and what I found on the web didn't make sense. I found how to create users and check their permissions using terminal. But I need to alter and create users and permissions through libpq or SQL directly. I also found there to be a reference on the INFORMATION_SCHEMA, but still couldn't make sense out of these tables in the given context. This is to make a user administration inside the client frontend. What approach would be recommended for this purpose?

Thanks
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-03-14 07:43:38 Re: Ways to edit users and permissions for database
Previous Message Martijn van Oosterhout 2012-03-14 07:38:44 Re: Interesting article, Facebook woes using MySQL